Jump to content

Archived

This topic is now archived and is closed to further replies.

phpnewbie322

Order by field

Recommended Posts

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?

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.