MSSQL Query

[obrienkev]

Hi all,

Any ideas why the below doesn't work? Gives the error. Table column names setup ok.
How do I check mssql query for errors? Anything better than die('Error: Class Query')? Thanks.

$query = "SELECT location_ID, class_date, class_start, class_end ".
			 	 "FROM class ".
				 "WHERE location_ID = '$location' ".
				 "AND class_date = '$meeting_date'";
echo '<br /><br />'.$query.'<br /><br />';
$result = mssql_query($query) or die('Error: Class Query');

Echoes as this...
SELECT location_ID, class_date, class_start, class_end FROM class WHERE location_ID = '1' AND class_date = '13/02/2006'

[rincewind456]

Could it be that your searching for a string 1 rather than an integer 1 as your location id

[obrienkev]

Doesn't give the error now but $num_results returns 0 even when it should be 1..
$num_results = mssql_num_rows($result);
echo 'Num_Results: '.$num_results.'<br /><br />';

I think its a date format issue. If $meeting_date is set to 13-02-2006 it works.

But for another table the above query works with date as 13/02/2006.

Why is this?

Thanks.