Re: Query Error
| From: | CPT John W. Holmes | Date: | Tue, 04 Nov 2003 16:03:47 +0000 |
| Subject: | Re: Query Error | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31415@lists.php.net to get a copy of this message | ||
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...