Selecting more than asked for
| From: | Alex Francis | Date: | Sat, 14 Dec 2002 19:37:52 +0000 |
| Subject: | Selecting more than asked for | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-24144@lists.php.net to get a copy of this message | ||
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 ";