Sure, You can.

order by FIELD1 [asc/desc], FIELD2 [asc/desc]

[...] = Optional
asc - is by default.

________________
Cheers!!!
Vijay G :-)

 Jefferis Peterson <jefferis@p...> wrote:Can you use an order by 2 different fields in succession like

By type then by name? I found that 2 items [view b and c of a] were added
manually in the database and although the key is the item name, they sort by
row numbers.... 

I need to call it back by name..

Jeff

~~~~~~~~~~~~
Jefferis Peterson, Pres.
Web Design and Marketing
http://www.PetersonSales.net
Tel .  xxx-xxx-xxxx
ICQ 19112253

http://www.Slippery-Rock.com - 7,000 hits per year
Such is God's economy: "One man gives freely, yet grows all the richer;
another withholds what he should give, and only suffers lack." - Proverbs
11:24 




---------------------------------
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site