[SOLVED] Question about $query

[phpfanphp]

Does anyone know why the following code keeps returning this 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 'ORDER BY position ASC'

 

	function get_pages_for_subject($subject_id)
{
	global $connection;
	$query = "SELECT * FROM tblpages WHERE subject_id = {$subject_id} ORDER BY position ASC";
	$page_set = mysql_query($query, $connection); 
	confirm_query($page_set);  //the function we made
	return $page_set;
}

 

Thanks!

[btherl]

Your subject_id is probably empty.  That's my first guess.

[phpfanphp]

Found it!  Thanks