I cant spot the error, can someone please help

raje

I keep getting this error"Parse error: syntax error, unexpected T_STRING", but i just cant spot the error. this is the line of code returning the error

$eq=$db->query("SELECT i.* FROM items i WHERE i.itmid IN({$odata['equip_primary']}, {$odata['equip_secondary']})");

Any help would be gratefully appreciated as i am still learning

halojoy

I cant tell about the query you use
because I do not use such advanced things as IN()

Actually I am not at all sure you have error in that posted line.
Might be the line before or even several lines before you have syntax issue.

But the only thing I can guess and know about is
to put single quotes around string data.
That is if these 2 data are strings:

IN ( '{$odata['equip_primary']}', '{$odata['equip_secondary']}' )

raje

i didnt write the code, so not sure about the IN statement to be honest. I tried what halo suggested and didnt make any difference (but thanx for the suggestion)

i'll attach the original unedited file (in text format), i get error message for line 185

laserlight

The error message is for PHP, not SQL. You probably should write:

$eq = $db->query("SELECT i.* FROM items i WHERE i.itmid IN('$odata[equip_primary]', '$odata[equip_secondary]')");

I assume that the contents of those variables have been properly escaped.

raje

thanx for the input laser (and yeah i knew it was a php error, it just happens to be comin up in an SQL section of the code lol), i tried ur suggestion as soon as i read ur reply, but still no difference.

but thanx for the help guys and girls 😃

laserlight

raje wrote:
i tried ur suggestion as soon as i read ur reply, but still no difference.

You must be mistaken, e.g., there was another error in the code.

djjjozsi

Before that SQL query you have an unclosed double qoute at the end of your form...

Next time you should post the previous 3 lines from your code.

raje

djjjozsi, thanx heaps mate, i closed off those double quotes and everything was fine 😃

thanx to all who helped