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? Quote Link to comment 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 Quote Link to comment 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! Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.