pesky T_LNUMBER error

[Mirlynn]

Hello everyone. I have been searching for a few hours for the answer to my dilemma and have not been able to figure out what is going on. The frustrating part is that it is probably something very simple.

My main issue is trying to run a query against my MySQL database to filter by a date (format - 2004-10-05). Here is the code:

$db = mysql_connect(IP, 'USER', 'PWD');

if (!$db) {
die('Could not connect: ' . mysql_error());
}

mysql_select_db("ivl", $db);

$result = mysql_query("SELECT * FROM matches WHERE date="2004-10-19" ORDER BY gym_id", $db);

I would appreciate any and all assistance anyone can give. I am trying to find the best way to query a date column with the same format above.

Thanks in advance for any and all help!

Mirlynn

[devinemke]

your quotes are screwing you up:

$result = mysql_query("SELECT * FROM matches WHERE date = '2004-10-19' ORDER BY gym_id");