Only list coming events ?

Results 1 to 2 of 2

Thread: Only list coming events ?

  1. #1
    Join Date
    Dec 1969

    Default Only list coming events ?

    Hello!<BR><BR>I would like to get only the rows with a date that is of today or forward in time(io, I don&#039;t want to list old happenings). "datum2" is in the mySQL db of the datatype <BR>date-format like "2003-03-23".<BR><BR>This is wrong, but the best I have come up with so far :)<BR><BR>$result = mysql_query("SELECT * FROM konferens WHERE datum2&#062;date() ORDER BY datum2",$db); <BR><BR>Huge thanks in advance<BR><BR>Klas

  2. #2
    Join Date
    Dec 1969

    Default Read the docs...<BR><BR>Find it? Down near the bottom of the page?<BR><BR>Oh, what the heck...look for CURDATE<BR><BR>The MySQL docs really are pretty good, if you are willing to take the time to learn how they are organized.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts