[SOLVED] MySQL Conditionals

[sennetta]

MySQL DB with "year" int[4], "month" int[2] and "day" int[2] columns.  I want to select all records from today, so (in PHP) I create a new Date() -

 

$year = Date("Y");
$month = Date("n");
$day = Date("j");

 

and stuff these into the $query statement:

 

SELECT * from table_name WHERE year>=".$year." && month>=".$month." && day>=".$day."

 

but of course that doesn't work because the month of the mysql record might be next year but less than the current month, and so, although the date of the mysql record might be after today, it does not get selected.

 

Is there a mysql command that says "if the current year is greater, ignore the next conditionals"?

 

Sorry this is more mysql question than php.

[BlueSkyIS]

SELECT * FROM table WHERE year <= 2007

 

i suggest not breaking up your dates as you've done. i would use a date field instead.

[sennetta]

Ended up using mktime to generate timestamp, and then using

 

"SELECT * from table_name WHERE time>=".$currentTime

as the SQL statement.

 

Many thanks for your help.