Zigster316 Posted August 24, 2007 Share Posted August 24, 2007 I am making a database that stores hockey players with their : Name Age Number Position How would I be able to make it so that if I displayed all the info in the table that it were to order it in by the player's number? Link to comment https://forums.phpfreaks.com/topic/66582-solved-ordering-a-table/ Share on other sites More sharing options...
amylou Posted August 24, 2007 Share Posted August 24, 2007 $query ="SELECT * FROM tablename ORDER BY 'number'; tablename= the name of your table. hope that helps you Link to comment https://forums.phpfreaks.com/topic/66582-solved-ordering-a-table/#findComment-333522 Share on other sites More sharing options...
Zigster316 Posted August 24, 2007 Author Share Posted August 24, 2007 That is exactly what I needed thanks. I am a newbie in this stuff so I love these forums! Link to comment https://forums.phpfreaks.com/topic/66582-solved-ordering-a-table/#findComment-333528 Share on other sites More sharing options...
amylou Posted August 24, 2007 Share Posted August 24, 2007 you are welcome, glad to help. i to am new to using mysql that is why i have a few posts in here. but i help when i know the answer Link to comment https://forums.phpfreaks.com/topic/66582-solved-ordering-a-table/#findComment-333530 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.