here's a dumb question, I have a database with a list of people in different states, most states have more than on person. How do I query it to only list the states once? Select * from table where state . . . . . . ?
are you trying to create a query that will provide for a "state list" kind of thing, that will display all the states where users are registered from?
Yes
$result = mysql_query("SELECT state FROM table GROUP BY state ASC");
will select state, group them and place the list in alphabetical order
Thank you, that worked!!
