Codes here !
Moderators: macek, egami, gesf
I have a bunch of event records for various event dates.
I want to write an select state that shows the following
sorted by state of course.
How do I do this.
thanks for any help
- New php-forum User
- Posts: 19
- Joined: Sun Apr 13, 2003 7:23 pm
- Code: Select all
SELECT State, COUNT(*) AS Count FROM tbl_name GROUP BY State ORDER BY State;
Answered pretty much the exact same question yesterday -- you might try a search of the board before posting next time.
- Posts: 2272
- Joined: Sat Jul 05, 2003 1:18 pm
- Location: A bunk in the back
Return to mySQL & php coding
Who is online
Users browsing this forum: No registered users and 1 guest