Simple SQL not working!

miseria · 03-29-2006, 02: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, 02:57 PM

"unique" is a mysql keyword.

Try changing the field name to is_unique or similar.

miseria · 03-29-2006, 03:04 PM

Muchas gracias amigo. Rep added!

03-29-2006, 02:57 PM	#2 (permalink)
TheLimey NamePros Member Join Date: Mar 2006 Posts: 29 0.00 NP$ (Donate)	"unique" is a mysql keyword. Try changing the field name to is_unique or similar. __________________ DNS Arena - Low cost domains starting at $7.95. Reseller accounts at $6.85. Censura - Reviews and Ratings Application. Ideal for community sites.

03-29-2006, 03:04 PM	#3 (permalink)
miseria SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 545 205.50 NP$ (Donate)	Muchas gracias amigo. Rep added! __________________ !!!!!!! see something you like? Accepting offers for great affiliate websites !!!!!!! Free Databases for your Website \| All Things Playstation 3 Website Design Books \| Music While You Work? \| Computer Gadgets

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