SQL sort question - ehMac.ca
Facebook
Twitter
YouTube
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read Advertise


Reply
 
LinkBack Thread Tools Display Modes
Old May 12th, 2003, 04:19 PM   #1
Honourable Citizen
 
Join Date: Aug 2001
Location: Hamilton, ON
Posts: 2,263
Post

Im thinking of a sql query statement where the result set is sorted by 2 columns at the same time is this possible?
For example if I have a list of items with titles and numbers, but it is the combination that is a unique key
would this work for example
SELECT * FROM TABLE ORDER BY TITLE, NUMBER
this is how I want the data
for example
APPLE 1
APPLE 2
BANNA 1
BANANA 2
any of you geniuses have any suggestions, if this would work in Mysql
or should I have separate tables for the Title list and item entries. My other idea is to select all the titles from a title table , then as I go down the title table , select all the entries in the item table and list them by number, this would work but needs an extra table and a couple extra lines of code, and we wouldnt want that.
__________________
Mark Innes
minnes is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old May 12th, 2003, 07:36 PM   #2
Honourable Citizen
 
Join Date: Mar 2000
Posts: 2,804
Post

What did you get when you tried it? That looks fine to me. You don't need separate tables for that.
hayesk is offline   Reply With Quote
Old May 13th, 2003, 12:20 PM   #3
Honourable Citizen
 
Join Date: Aug 2001
Location: Hamilton, ON
Posts: 2,263
Post

Hi hayesk
Thanks for the reply
Im juist in the middle of setting up a personal web site with some mysql tables
So, it will be a while, before I get it all functional.
Do you do much database, sql, Oracle or mysql programming?
Im finding it kind of fun to be able to get data displayed in web pages from MySql tables.
__________________
Mark Innes
minnes is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple question Snapple Quaffer Everything Else, eh! 12 Sep 12th, 2005 05:36 PM
Question concerning newly downloaded widgets... Elias26 Anything Mac 5 Sep 10th, 2005 10:40 PM
Photoshop CS question... MacGYVER Mac, iPhone, iPad and iPod Help & Troubleshooting 3 Apr 27th, 2005 10:10 PM
Question about stainless steel for chemists Toca Loca Nation Everything Else, eh! 2 Apr 17th, 2005 01:28 PM
Sort of a MAc/iPod question - Speakers baxtersbestpal Anything Mac 8 Dec 14th, 2004 10:18 PM


All times are GMT -4. The time now is 01:43 AM.



Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
Copyright 1999 - 2012, ehMac.ca All rights reserved. ehMac is not affiliated with Apple Inc. Mac, iPod, iTunes, iPhone, Apple TV are trademarks of Apple Inc. Content Relevant URLs by vBSEO 3.6.0 RC 2

Tribe.ca: Urban living in Toronto!