Re: [PHP-WIN] Query to MySQL

2002-09-25 Thread Cam Dunstan
Marlene You need to convert the current date to a string of the form "yyy-mm-dd hh:mm:ss" and write your query as follows $datestring = date("Y-m-d H:i:s", $some_time_stamp_integer); - or for this very day today $datestring = date("Y-m-d H:i:s"); // returns today if no optional timestamp gi

Re: [PHP-WIN] Query to MySQL

2002-09-25 Thread Daniel Gustafsson
I bet you it's the ' around the currentdate()-function that causes it to interpret it as a string instead of a function call. And afaik there is no currentdate()-function in mysql, it's now(). At 15:02 2002-09-25 -0400, Marlene Burckhalter wrote: >I am trying to display an event calendar in an