[SOLVED] Eliminate Duplicates from MySQL Results

[siamiam]

I'm trying to output:

 

City Name, State Abbreviation

 

I currently have the following code:

 

$result = mysql_query("SELECT * FROM exp_weblog_data");

while($row = mysql_fetch_array($result))
  {
  echo $row['field_id_10'] . ", " . $row['field_id_11'];
  echo "<br />";
  }

 

The above code works, partially. It produces the following:

 

St. John's, NL

New York, NY

New York, NY

New York, NY

New York, NY

Los Angeles, CA

San Francisco, CA

Los Angeles, CA

 

I need assistance on how to remove the duplicates. I read information about using "array_unique" but I'm unsure of where to start using that function within the code I currently have.

 

I would really appreciate it if someone could point me in the right direction.

 

Thanks!

[cunoodle2]

Why are you selecting "*" if you are only using 2 columns?

 

Try this..

 

SELECT DISTINCT city, state FROM exp_weblog_data;

 

Something like that should get you going in the right direction.  Also note that you will need to modify the above query with the actual column names (as apposed to "city" and "state" like I am using).  Just replace those with whatever your column names are.

[siamiam]

aaah! Thanks so much! I wasn't familiar with 'DISTINCT' I guess I was overcomplicating it.