Strings in your sql query must be quoted. Try this instead:
$result = mysql_query(SELECT * FROM ar
LEFT JOIN company on ar.company_id=company.company_id
LEFT JOIN scale on ar.scale_id=scale.scale_id
WHERE item_number = \$item[$index]\);
Fred
Jordan [EMAIL PROTECTED] wrote in
I tried but nothing different happened. I'm still playing though and I'll
see if I can make it work. I'm new to all of this...so we'll see how it
goes. Thanks for your help.
-jordan
Fred [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Strings in your sql
First, make sure $item[$index] has anything in it by inserting an
echo $item[$index].
You also have to prepend item_number with the table name as in ar.item_number.
Try single quotes around $item[$index], too.
If $index is a name, I've had trouble in the past getting associative
arrays to
3 matches
Mail list logo