Jump to content


Photo

Order by


  • Please log in to reply
1 reply to this topic

#1 Charlotte

Charlotte
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 15 February 2003 - 03:45 PM

Is it possible to write a mySQL-statement like this?

… ORDER BY Something ASC, Another_Thing DESC

I only end up with “Supplied argument is not a valid MySQL result “
Is there any other way I can solve this problem?

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 15 February 2003 - 05:06 PM

the order by is fine. the \"not a valid result\" means a few things:

1 the database was not connected to properly
2 a database was not selected properly
3 the query has faulty syntax
4 there are simply no results for that query

try running your query ad hoc at the mysql cmd line and see if you get something back.
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users