[SOLVED] Display record once

[erme]

I'm trying to write the html header from a field called County. The below works, however it displays County for how many records there are with that county. How would I change it so it only displays it once? At a guess, I would say mysql_fetch_array is wrong??

 

$pagetitle = mysql_query("SELECT * FROM $Table");
while($r = mysql_fetch_array($pagetitle))
  {
    echo "<h2>" . $r['County'] . "</h2>\n";
  }

[trq]

SELECT DISTINCT County FROM $table

[Bjom]

"SELECT DISTINCT `Country` FROM $Table"

[watsmyname]

I'm trying to write the html header from a field called County. The below works, however it displays County for how many records there are with that county. How would I change it so it only displays it once? At a guess, I would say mysql_fetch_array is wrong??

 

$pagetitle = mysql_query("SELECT * FROM $Table");
while($r = mysql_fetch_array($pagetitle))
  {
    echo "<h2>" . $r['County'] . "</h2>\n";
  }

if you retrieving just one database field why you are using select * ... ?? and to your question thorpe has already answered it.

[erme]

Thanks people