Simple MySQL select question
Posted: Fri Jun 03, 2005 11:28 am
I have a table titled users and within the table there is a field titled division (either 1,2,3,4) - on a page that displays all members, i would like to group them by division - but leave spacing between divisions. I know I could use this: - but i would like to know how to select by the field? sorry if its confusing, new to php and still learning it. thanks
Code: Select all
SELECT * FROM users ORDER BY division