| Neil Smith [MVP, Digital media] 2007-01-22, 8:01 am |
| 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
|