Re: [PHP-WIN] Query to MySQL

2002-09-25 Thread Cam Dunstan
mber of seconds since ages ago - 1972 I think) datetime is a string - e.g. "2002-09-24 10:30:00" hope this helps - Original Message - From: "Marlene Burckhalter" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 26, 2002 5:02 AM Subject:

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

[PHP-WIN] Query to MySQL

2002-09-25 Thread Marlene Burckhalter
I am trying to display an event calendar in an html document ( I am a beginner, I had to start small). My problem is the following query displays all the records instead of just the ones with the event date greater than or equal to the current date. Any suggestions to a begginer? Here is a sni