August 16th, 2000, 01:29 PM
I have a script that has the following field names.
name, email, state, mtn, and review
I know how to add these to the database and loop through them all, but I want the looping page to show the entries in order by the "state" they choose. It will be a drop down menu with the state names like "NJ and PA" And on the looping page it puts all the rows in order by the state.
So would I go through and use "if" statements for all 50 states? Or is there a simpler way top do this. Thank you.
August 17th, 2000, 07:19 AM
in your sql query juste state "order by 'state' "
That's do the job for you.