Jump to content


Photo

Order by field


  • Please log in to reply
1 reply to this topic

#1 phpnewbie322

phpnewbie322
  • Members
  • Pip
  • Newbie
  • 1 posts

Posted 02 January 2004 - 06:29 AM

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?

#2 gizmola

gizmola
  • Administrators
  • Advanced Member
  • 4,664 posts
  • LocationLos Angeles, CA USA

Posted 02 January 2004 - 09:50 AM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users