RE: [PHP-DB] Query Error
| From: | Robert Sossomon | Date: | Tue, 04 Nov 2003 16:07:25 +0000 |
| Subject: | RE: [PHP-DB] Query Error | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31416@lists.php.net to get a copy of this message | ||
The errors as it prints are:
The query I just ran was: select * from GCN_items where
item_num =
'%fm-a294%'
The query I just ran was: Resource id #2
0
-----Original Message-----
From: CPT John W. Holmes [mailto:holmes072000@charter.net]
Sent: Tuesday, November 04, 2003 11:04 AM
To: Robert Sossomon; php-db@lists.php.net
Subject: Re: [PHP-DB] Query Error
From: "Robert Sossomon" <robert@gcnorris.com>
> And here is the additem.php file where it check for the info in the
> field and it is erroring out.
It would be rather useful to know the error...
> $get_iteminfo = "select * from GCN_items where 'item_num' LIKE
> '%$_POST[sel_item_id]%'";
Take away the single quotes around your column name. You're asking for a
'string' LIKE 'another string' and not comparing anything in your column
at all.
You can use backticks around table and column names, though. Maybe
that's what you're trying to achieve.
$get_iteminfo = "select * from GCN_items where item_num LIKE
'%$_POST[sel_item_id]%'";
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php