Jump to content


Photo

Query using dates


  • Please log in to reply
1 reply to this topic

#1 Mateobus

Mateobus
  • Members
  • PipPipPip
  • Advanced Member
  • 95 posts

Posted 07 August 2006 - 03:26 PM

I have rows listed in my database where there is 1 column called the date column that is a date element (XXXX-XX-XX).  How do I run a select query that selects only the rows where the date is today or before today...

#2 ryanlwh

ryanlwh
  • Staff Alumni
  • Advanced Member
  • 511 posts

Posted 07 August 2006 - 03:31 PM

SELECT * FROM table WHERE date=CURDATE()

Please use EDIT * 100...
Please use
or [php] * 1000...

PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users