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:
Code: Select all
SELECT * FROM users ORDER BY division
- but i would like to know how to select by the field? sorry if its confusing, new to php and still learning it. thanks