SQL SELECT statement problem

[Hatch]

I'm getting this error...

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in gs_functions.php on line 1835

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in gs_functions.php on line 1843

From this code here...

		// Guides NOT Available
		$query = "SELECT gs_group.guideno,gs_guide.name
				  FROM gs_group,gs_guide
				  WHERE ($from_date >= arrdate AND $from_date <= depdate) OR
				  ($to_date >= arrdate AND $to_date <= depdate)";
		$result = mysql_query($query);
		$num_results = mysql_num_rows($result);

	// Guides Available
	$query2 = "SELECT gs_group.guideno,gs_guide.name
			   FROM gs_group,gs_guide
			   WHERE ($to_date < arrdate OR $to_date > depdate) AND 
			   ($from_date < arrdate OR $from_date > dep_date)";
	$result2 = mysql_query($query2);
	$num_results2 = mysql_num_rows($result2);

I thought these select statements would work. "arrdate" and "depdate" are the names of fields in the table gs_group. (arrival date and departure date)

Any help would be greatly appreciated.

[LordShryku]

Use [man]mysql_error[/man]

[Hatch]

Now I get this error from mysql_error

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '00:00:00 >= gs_group.arrdate AND 2004-03-04 00:00:00 <= gs_grou
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in gs_functions.php on line 1840
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '00:00:00 < gs_group.arrdate OR 2004-03-12 00:00:00 > gs_group.d
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in gs_functions.php on line 1850

Also...this is where I get $from_date and $to_date from.

		$from_date = date("Y-m-d 00:00:00",mktime(0,0,0,$from_month,$from_day,$from_year));
		$to_date = date("Y-m-d 00:00:00",mktime(0,0,0,$to_month,$to_day,$to_year));

[broc7]

I believe mysql likes its date values in quotes. That's why the error starts at the time part- it was interpreting the date part as subtraction and didn't know what to do with 0's and colons after that. (I think.)

[Hatch]

Thanks broc. I should've known to put quotes around the values. It skipped my mind though.