$SQL = " SELECT * FROM resources where unit_id='{$unit_id}' order by level
";
Ignatius
____________________________________________
----- 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
