php / MySQL: You have an error in your SQL syntax error

FirstBorn · 12-31-2008, 06:59 AM

Hi,

Thank you for reading.

I'm getting an error in My Query for some reason
and can't pinpoint EXACTLY where in the statement.

Here is what I currently have that is generating
the error:

Code:

		$query="SELECT * FROM directory WHERE active='1'
		AND column='L' AND type='paid' ORDER BY sortorder ASC";
		
		$result = mysql_query ($query) or die(mysql_error());

Here is the error:

Quote:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'column='L' AND type='paid' ORDER BY sortorder ASC' at line 2

I've tried all different combinations,
all to no avail.

I know that it's got to be something simple and
something that I'm just overlooking.

Any Ideas?

Thank you Very Much for Your help in advance.

Thanks,
FirstBorn

Mega Man X · 12-31-2008, 08:20 AM

I can't see anything wrong with the statement, but I can't test it right now either

. What I would recommend you to do is to print out the $query variable to see what exactly it contains, eg:

echo '$query';

I do that all the time I face a SQL query mixed with code of some sort and need to debug it

P.S: not a PHP programmer myself.

Regards!

FirstBorn · 12-31-2008, 09:59 AM

Hi Mega Man,

Thanks.

I figured it out.

The word 'column' seems to be an 'operator' type
word that doesn't seem to work with the naming
conventions of field names...

So, I changed the field name 'column' to 'location'
and edited the SQL Query accordingly and it now works.

Thank you again for jumping in to help.
Your "echo "$query";" helped.

Thanks,
FirstBorn

----------------------------------

Quote:

Originally Posted by Mega Man X

I can't see anything wrong with the statement, but I can't test it right now either

. What I would recommend you to do is to print out the $query variable to see what exactly it contains, eg:

echo '$query';

I do that all the time I face a SQL query mixed with code of some sort and need to debug it

P.S: not a PHP programmer myself.

Regards!

Mega Man X · 12-31-2008, 01:49 PM

Awesome, I'm glad you figured it out FirstBorn

Happy new your to you by the way

-X

FirstBorn · 12-31-2008, 05:26 PM

Quote:

Originally Posted by Mega Man X

Awesome, I'm glad you figured it out FirstBorn

Happy new your to you by the way

-X

Hey X,

Happy New Year to You, too!

Hope that it's the best ever for You.

Thanks,
FirstBorn

jiml8 · 12-31-2008, 05:39 PM

The way I usually figure out such issues is to echo out the query, then feed the echoed output into phpmyadmin and take a look at the useful response that phpmyadmin gives. If phpmyadmin is not available, you can also feed the query into the command line mysql command shell, or you can use something like MySQL Administrator.

FirstBorn · 12-31-2008, 05:46 PM

Quote:

Originally Posted by jiml8

The way I usually figure out such issues is to echo out the query, then feed the echoed output into phpmyadmin and take a look at the useful response that phpmyadmin gives. If phpmyadmin is not available, you can also feed the query into the command line mysql command shell, or you can use something like MySQL Administrator.

Hi jiml8,

Thanks.

Actually, that's how I figured out the issue
with the fieldname...

I tried the Query individually until I noticed
that all of the other fieldnames alone were not
generating errors, but the 'column' fieldname
generated an error (I believe it was a 1064 or
something like that.)

I didn't even think to check there until X
mentioned to echo the query in the script...

It was one of those 'a-ha' moments...

Thanks,
FirstBorn