i have 2 columns:
1)pages_id (the id's of pages 1,2,3...)
2)pages_paid(yes,no)
...
i need in my query to SELECT...FROM...WHERE...ORDERY BY:first where pages_paid='yes' and then by id...i mean: the pages_paid be first...and then to order the other products by id :S...please
Hi,i need some help in ORDER BY
Moderator: General Moderators
- social_experiment
- DevNet Master
- Posts: 2793
- Joined: Sun Feb 15, 2009 11:08 am
- Location: .za
Re: Hi,i need some help in ORDER BY
Have a look at example 4 on the page below
http://www.techonthenet.com/sql/order_by.php
http://www.techonthenet.com/sql/order_by.php
“Don’t worry if it doesn’t work right. If everything did, you’d be out of a job.” - Mosher’s Law of Software Engineering