At 16:26 21/01/2007, you wrote:
I have a date field in mysql called event_end .
I want to run a query to find all records where the event_and is greater
than today's date. I have written the following code. It does not work.
Please point out the mistake.
$today = getdate();
$sql="select * from events where event_end>'.$today.' order by event_start
Asc ";
Because PHP allows you to quote variables inside strings surrounded
by " " characters, your string $sql passed to the database will
actually be as follows
select * from events where event_end>'.array.' order by event_start
which you would have seen if you had used print($sql) to debug this.
The reason if prints "array" is because - well getdate() returns an
array, which you would have seen if you'd RTFM : array getdate ( [int
timestamp] ).
And there are dots surrounding the word `array` because - well, you
put them there and used single quotes to ensure they were output
literally in the string, rather than closing the string using a
matching double quote character then re-opening it with another
double quote character after the $today variable.
Probably I would use the date() function to generate that date as a
*string*, and make sure I quoted that string correctly when making
the $sql string, eg like
$today = date('Y/m/d');
$sql = "SELECT * FROM events WHERE event_end> '".$today."' ORDER BY
event_start ASC";
Cheers - Neil
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
