perficut Posted November 23, 2008 Share Posted November 23, 2008 I have a database that stores a service record of a contractor. such as, ContractorsName, ServiceDate, PropertyServiced, TimeServiced, and so on. Each contractor may have 5 or more properties they serviced. So I want to display a summary of record sorted by contractor, then by property. Example B&M Electrician - Verizon Property 12:30pm repaired outlet - McDonalds 13:45pm replaced solenoid - KFC 14.35m no work needed HC Plumbing - Police Station 9:30am replaced sink faucet - gas station 10:45am fix drain clog Any help to get me in the right direction would be great. Link to comment https://forums.phpfreaks.com/topic/133909-3-way-sort-of-mysql/ Share on other sites More sharing options...
Mchl Posted November 23, 2008 Share Posted November 23, 2008 ORDER BY ContractorsName ASC, PropertyServiced ASC Link to comment https://forums.phpfreaks.com/topic/133909-3-way-sort-of-mysql/#findComment-697045 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.