[SOLVED] Mysql - datetime query

[shotos]

Hi

i have a table with several columns of which one is of type datetime.

i want to output rows with a specific date say 24-08-2008.

but i keep getting this error

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/kwasi/public_html/call.php on line 151

 

this is my code

$query = "select * from Element_$header where year(date_field)='$year' and month(date_field)='$month' and day(day_field)='$day'";

				$result = mysql_query($query,$db->link);

				if(mysql_num_rows($result))

[Mchl]

Apparently your query didn't succeed.

 

Use:

if(!$result = mysql_query($query,$db->link)) {
echo mysql_error();
}

to echo error information

[shotos]

i got it now.

it was a mistake in the column name

tanx