RE: [PHP-DB] SELECT statement
| From: | Sam Masiello | Date: | Mon, 11 Dec 2000 21:32:05 +0000 |
| Subject: | RE: [PHP-DB] SELECT statement | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5165@lists.php.net to get a copy of this message | ||
The easiest way is to do it exactly how you explained it (simple, eh?) ?
If ((!isset($number)) || (!is_integer($number))) {
Do something ;
}
else {
Do something else ;
}
The example above assumes that $number is an integer, but you get the idea
:)
HTH
Sam Masiello
System Analyst
Chek.Com
(716) 853-1362 x289
smasiello@chekinc.com
-----Original Message-----
From: Julio Cuz, Jr. [mailto:jcuz@rccd.cc.ca.us]
Sent: Monday, December 11, 2000 3:59 PM
To: php-db@lists.php.net
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