date field mysql is driving me up the wall

[Cep]

Hello,

I have a simple table with a date field, which has 4 records, 2 of which contain the date 2007-01-07

In my sql I have stated,

[code=php:0]
$gsql = "SELECT * FROM cw_games WHERE gamedate = '2007-01-07'";
[/code]

The error I receive is,

Function: get_lastgames
SELECT gsql:
SELECT * FROM cw_games WHERE gamedate = '2007-01-07'
SQL ERROR: Query was empty

This makes no sense to me at all, even the date field type on MySQL's website suggests that the format is always input and output as YYYY-MM-DD so why is my query not picking up the fact that there are two records within the 4 that have the date 2007-01-07 ?

[paul2463]

silly question but worthy of an ask
the column in your database is it type 'date' or type 'datetime'?

[paul2463]

you could always tru the following anyway
[code]
$gsql = "SELECT * FROM cw_games WHERE DATE_FORMAT("%Y-%m-%d",gamedate) = '2007-01-07'";
[/code]

which will format what date you have in there to the way you are checking for it

[Cep]

its set to date, I can clearly see the date when I browse the table in phpmyadmin and there are two rows with the date 2007-01-07.

I am literally reading in a string,

$date = "2007-01-07";

$gsql = "SELECT * FROM cw_games WHERE gamedate = '{$date}'";

[paul2463]

$gsql = "SELECT * FROM cw_games WHERE gamedate = '$date'";

remove the curly braces they are not needed any more

[Cep]

Ah ok cheers!