Apache 1.3.23 + PHP 4.1.2 + PostgreSQl 7.2
I have a guestbook that I would like to display the current month's entries.
I can display all the entries before the current month, but i can't seem to
figure out how to extract the currrent month's.
Advertising
Although the code below is a db issue, I don't know whether I should write
code to extract the info before or after the db connection. Should I:
1. Set up the parameters beforehand in PHP, and then do a query;
2. Within the query itself (as the code I tried [and didn't work] below);
3. Or, somehow in PHP, after I get all the results [obviously without the
db WHERE clause].
<?php
// lots of code
$db = pg_connect("dbname=rap user=postgres");
$query = "SELECT * FROM guest WHERE pdate = "{$_SESSION['pdate'] ==
date('Y-m')"; // pdate is formatted ('Y-m-d')
// etc, etc. . .
?>
I know this is a simple question -- but my mind's totally blotto after a
day's coding.
Any help, pointers of where to look, or admonitions will be gratefully
accepted.
Tia,
Andre
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php