Order by field

[phpnewbie322]

I have a 2 fields called sales and price. Within the sales field there is records \'sales center\', \'agentnames\'(agentnames is the names for the agents). I want to order by price but list the agentnames first which will be ordered by price then list the sales center ordered by price. Is there a way i can do this?

[gizmola]

I have a 2 fields called sales and price. Within the sales field there is records \'sales center\', \'agentnames\'(agentnames is the names for the agents). I want to order by price but list the agentnames first which will be ordered by price then list the sales center ordered by price. Is there a way i can do this?

 

Can we get some terminology straight? You say you have 2 fields called sales and price, but it sounds like you have two \"Tables\".

 

Mysql works like this:

 

Database contains

--Tables are defined by a set of

----Columns

 

You insert Rows into a Table. (A row is synonymous with a \"Record\" or \"Tuple\")

 

Your misuse of the proper terminology makes it impossible to answer your question with anything but a guess.