MYSql Order By Problem???
Posted: Wed Jun 17, 2009 12:14 pm
Hey guys I have a this query im trying to run and its not really working...
but it throws an error at me stating there is an error in my syntax... and anyway i try to make it work its not wanting to work correctly? Is it possible to use the WHERE clause with the order by? 
After posting this topic and placing my SQL statement in the code box I realized that SQL was interpreting my "order" field as another ORDER so, changed the name of the order field and walla it worked. No longer need help on this. Thanks though!

Code: Select all
SELECT * FROM menu_items WHERE parent = ? ORDER BY ORDER DESCAfter posting this topic and placing my SQL statement in the code box I realized that SQL was interpreting my "order" field as another ORDER so, changed the name of the order field and walla it worked. No longer need help on this. Thanks though!