Re: SELECT statement
| From: | Louis Aslett | Date: | Mon, 11 Dec 2000 21:14:15 +0000 |
| Subject: | Re: SELECT statement | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5163@lists.php.net to get a copy of this message | ||
Hi again Julio!
I'd try this:
if( $number && is_integer($number) ) {
$sql = "SELECT * FROM Facilities WHERE WO=$number";
}
else {
.. do error stuff ..
}
There is also is_long(), is_double(), is_float() etc depending what number
you expect.
Louis
----- Original Message -----
From: Julio Cuz, Jr. <jcuz@rccd.cc.ca.us>
To: <php-db@lists.php.net>
Sent: Monday, December 11, 2000 8:58 PM
Subject: [PHP-DB] SELECT statement
> Hi--
>
> Let's say I'm doing this:
>
> $sql = "SELECT * FROM Facilities WHERE WO=$number";
>
> What if "$number" doesn't exist OR is NOT an integer for example, how can
I
> trap that error and display a message? Or other idea?
>
> Thanks a lot!
>
>
> Julio Cuz, Jr.
> Riverside Community College
> jcuz@rccd.cc.ca.us