You shouldnt get any syntax errors i think use $sql = "SELECT * FROM resources WHERE unit_id='$unit_id' AND unit_id IS NOT NULL ORDER BY level"; as far as your unit_id is DEFAULT NULL. Otherwise try using WHERE unit_id<>0 AND unit_id<>'' or something like this, depending on your type of variable. If this isn't solving your problem, show us more source-code and the table-columns definition. greets ag ----- Original Message ----- From: "Alex Francis" <afrancis@camerondesign.co.uk> To: <php-db@lists.php.net> Sent: Saturday, December 14, 2002 8:37 PM Subject: Selecting more than asked for 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
