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 re
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 q
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]> w
3 matches
Mail list logo
