When using the statement below, as well as getting the data corresponding to
$unit_id, I also get any data where unit_id field is blank. I have tried
various permutations of unit_id IS NOT NULL, but get syntax errors. Can
someone help to get the syntax correct.

$SQL = " SELECT * FROM resources where unit_id='$unit_id' order by level ";




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to