|
|
Posted by Frankie on 07/28/06 18:51
I'm trying to run the following search query:
$query =
sprintf ("SELECT itemNumber, thumbnailURL, title, description, price
FROM apparel,hats
WHERE apparel.title OR apparel.description OR hats.title OR
hats.description
LIKE '%s'",
$_POST['tfSearch']);
but it returns this error:
"Column: 'itemNumber' in field list is ambiguous"
Both "apparel" and "hats" tables share the same columns specified in the
SELECT clause.
What I'm I missing?
Frank H.
Austin, TX
Navigation:
[Reply to this message]
|