Jump to content


Photo

Help with SQL Query(SELECT)


  • Please log in to reply
2 replies to this topic

#1 elhama

elhama
  • Members
  • PipPip
  • Member
  • 19 posts

Posted 13 August 2006 - 03:58 AM

What I want to do is to SELECT * from members, but I want to order it by 'type' (order by type DESC), but I want it to also to order by category in the second hand, kinda hard to explain, do anyone understand what I'm trying to do? Thanks!

#2 Chetan

Chetan
  • Members
  • PipPipPip
  • Advanced Member
  • 162 posts
  • LocationIndia

Posted 13 August 2006 - 04:00 AM

I hav dun this wid oracle lets try here
SELECT * FROM members ORDER BY type,category DESC;

I am a PHP Guru, ask me questions if you want to

#3 elhama

elhama
  • Members
  • PipPip
  • Member
  • 19 posts

Posted 13 August 2006 - 04:00 AM

Ah damn it! I didn't realize it was that simple! :D Haaha! Thanks alot mate!! ;)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users