Re: Selecting more than asked for
| From: | Ignatius Reilly | Date: | Sat, 14 Dec 2002 20:18:50 +0000 |
| Subject: | Re: Selecting more than asked for | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-24145@lists.php.net to get a copy of this message | ||
$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: [PHP-DB] 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
>
>