[t_hah]

I am working with php and mysql.
I have two columns set up in a database. One is year, the second one is month. For simplicity let's say that they are both integer numbers.

I want to select everything from the database that is for this year and beyond, starting from the current month.

This is what I have so far:

today_year=date("Y");
today_month=date("m");
$query="select * from $db where year>=$today_year and $month=$today_month";

how can I tell the database, that I want everything from the current month in the present year, plus everything for years after?

Thanks,


t

[Arkham_c]

Why would you store month and year as integers? Store dates as dates, and you get lots of nice query functions that would require lots of logic otherwise.

[philzilla]

Web Developer
For discussion of languages, databases, or anything else related to Web deployment

eh?

oh, and what Arkham_c said, about dates

[wallinbl]

Originally posted by t_hah:
I am working with php and mysql.
I have two columns set up in a database. One is year, the second one is month. For simplicity let's say that they are both integer numbers.

I want to select everything from the database that is for this year and beyond, starting from the current month.

This is what I have so far:

today_year=date("Y");
today_month=date("m");
$query="select * from $db where year>=$today_year and $month=$today_month";

how can I tell the database, that I want everything from the current month in the present year, plus everything for years after?

Thanks,


t

SELECT * FROM [table] WHERE (year = 2003 AND month >= 9) or year > 2003

But, you really should just store dates as actual dates. That way, you can just say:

SELECT * FROM [table] WHERE order_date >= '2003-09-01'