SELECT statement
| From: | Julio Cuz, Jr. | Date: | Wed, 04 Apr 2001 22:24:31 +0000 |
| Subject: | SELECT statement | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8219@lists.php.net to get a copy of this message | ||
Hi--
Every time I run the following code, I get this error if I use a NUMBER for the 'Email' case:
"Warning: Unable to jump to row 0 on PostgreSQL result index 2 in /html/rccd/remodel/display2.php on line 35"
or, if I use a string (i.e. jcuz@rccd.cc.ca.us), I get this error message:
"Warning: PostgreSQL query failed: ERROR: Attribute 'jcuz' not found in /html/rccd/remodel/display2.php on line 33"
Please help!
------------------------------------------------
switch ($Search) {
case "WO":
settype ($find,integer);
$sql = "SELECT * FROM \"Remodel\" WHERE \"WO\" LIKE $find";
break;
case "Email":
$sql = "SELECT * FROM \"Remodel\" WHERE \"Email\" LIKE $find";
break;
}
--------------------------------------------------
Julio Cuz, Jr.
Riverside Community College
jcuz@rccd.cc.ca.us