[RESOLVED] DATE COMPARISON - Todays date

[mpasternak]

I know this should be simple but i can't figure it out for the life of me

I'm trying to do an SQL statement with a date comparison.

basically.

SELECT * FROM ICE_TIME WHERE START_DATE > TODAY

the database is a MYSQL database and START_DATE is a DATETIME field

[bradgrafelman]

In the MySQL manual on the Date and Time Functions page, you'll find this function: NOW().

[mpasternak]

yes, i'm a dork

here's the answer. was so simple. thank yoU!!!

"SELECT * FROM ice_time WHERE ARENA_ID='$_GET[A_ID]' AND END_DATE >= NOW()"

was THAT EASY

[bradgrafelman]

Also note that it appears as though you're vulnerable to SQL injection attacks. User-supplied data should never be placed directly into a SQL query! Instead, sanitize it with a function such as [man]mysql_real_escape_string/man.

[mpasternak]

so for safety sake i should be doing

$A_ID=mysql_real_escape_string($_GET['A_ID']);

and then using $A_ID variable in my SQL statements directly?

[bradgrafelman]

Yes. Or, if you're expecting A_ID to be an integer, you could cast the $_GET['A_ID'] variable to an integer or use [man]intval/man.