SQL syntax error line 1

[jeliot]

Newbie question

when the SQL error says line on does that mean line of the whole HTML/PHP script or just the first line of the actuall php script in the HTML script

thanks

[Barand]

It means the first line of the SQL query

If you put the query all on one line then the error, if there is one, wil always be on line 1.

[code]SELECT a.cola, b.colb, b.colc FROM table1 a INNER JOIN table2 b ON a.cola = b.cola WHERE b.colc = '$x' AND b.colx = 42[/code]

or you could split it over several lines

[code]SELECT a.cola, b.colb, b.colc
FROM table1 a
        INNER JOIN table2 b ON a.cola = b.cola
WHERE b.colc = '$x'
        AND b.colx = 42[/code]

[jeliot]

[!--quoteo(post=360686:date=Apr 1 2006, 03:13 PM:name=Barand)--][div class=\'quotetop\']QUOTE(Barand @ Apr 1 2006, 03:13 PM) [snapback]360686[/snapback][/div][div class=\'quotemain\'][!--quotec--]
It means the first line of the SQL query

If you put the query all on one line then the error, if there is one, wil always be on line 1.

[code]SELECT a.cola, b.colb, b.colc FROM table1 a INNER JOIN table2 b ON a.cola = b.cola WHERE b.colc = '$x' AND b.colx = 42[/code]

or you could split it over several lines

[code]SELECT a.cola, b.colb, b.colc
FROM table1 a
        INNER JOIN table2 b ON a.cola = b.cola
WHERE b.colc = '$x'
        AND b.colx = 42[/code]
[/quote]


thanks atleast i have a starting point to find the problem