[RESOLVED] date + Select Query

[obrienkev]

Hi all,

The below query when echoes gives this result: SELECT * FROM class WHERE class_date = 2006-01-03

However when I echo mysql_num_rows it gives 0 results even though the same date is in the db table.
class_date is set as date type in mysql db.

$query = "SELECT * ".
	       "FROM class ".
	       "WHERE  class_date = $class_date";

Thanks.

Kevin.

[devinemke]

you forgot the quotes:

$query = "SELECT * FROM class WHERE class_date = '$class_date'";

[obrienkev]

Of course. Its the simple ones catching me today. 😃

Thanks devinemke