Syntax Problem (Was : Date problem)

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