Thanks to everyone for your help. It was my own stupidity which was collecting the wrong data. I wasn't passing the value of unit_id to my table. "Andre gemünd" <ag@mattheus.de> wrote in message 000b01c2a3af$753d2160$596d8550@lithium3">news:000b01c2a3af$753d2160$596d8550@lithium3... > 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
