Simple SQL not working!

Encenta.com · 03-29-2006, 03:17 PM

Am I getting stupid in my young age or is my host just [insert rude word here]?

I've had many problems with my host so far and this is the second (simple) MySQL problem I've had today.

PHP Code:

  $query = mysql_query( "SELECT * FROM certificates WHERE unique='1' ORDER BY title ASC" ) or die("SELECT Error: " .mysql_error());

Returns:

Quote:

SELECT Error: 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 'unique='1' ORDER BY title ASC' at line 1

Hopefully I'm just stupid. Thanks.

Furthermore: when I changed 'unique' to 'category', it worked fine. These two fields are identical in the database (including properties) so the only way it could be wrong is if 'unique' is not spelt the same way it is in the database and i've checked it billions of times.

TheLimey · 03-29-2006, 03:57 PM

"unique" is a mysql keyword.

Try changing the field name to is_unique or similar.

Encenta.com · 03-29-2006, 04:04 PM

Muchas gracias amigo. Rep added!

03-29-2006, 03:57 PM	#2 (permalink)
TheLimey NamePros Member Join Date: Mar 2006 Posts: 30	"unique" is a mysql keyword. Try changing the field name to is_unique or similar. __________________ DNS Arena - Low cost domains. Reseller accounts at $8.75.

03-29-2006, 04:04 PM	THREAD STARTER #3 (permalink)
Encenta.com SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 573 Follow @MiseriaSK	Muchas gracias amigo. Rep added! __________________ Encenta - Amazon Associates CMS

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)