|
| |
|
|
pmagas
Posts: 374
Joined: 3/26/2002
From: St. Louis MO USA
Status: offline
 |
'Order By' Question - 9/15/2005 14:09:42
I have a DRW (on the Spooky diet) with an Order By and everything works fine.  I'd like to add another order by in there. Can I do that? And what's the syntax?
Not sure if I'm clear - I want it to order by status (ascending), then within status, I want to order it by date (descending.) But I don't know if it can be done and I'm not sure how to write it without 'wrecking' everything. The good news is that since it's not broken, it's not urgent.
Thanks for any guidance you might offer.
Cheers!!
_____________________________
Penny
humble webmaster of
We Sell St. Louis
http://www.WeSellStLouis.com
http://www.MarkSellsStLouis.net
http://www.sitekickdesigns.biz/
http://www.yousellrealestate.net/
|
|
|
|
BeTheBall
Posts: 6502
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: 'Order By' Question - 9/15/2005 15:47:30
Like this:
ORDER BY status asc, date desc
Change status and date to the actual field names.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 