[SOLVED] Remove repetitions

[Bricktop]

Dear all,

 

I have a very simple PHP script as follows:

 

$sql = mysql_query("SELECT * FROM personaldata ORDER BY surname ASC");

	while ($a = mysql_fetch_array($sql))
	{
$content .= ''.stripslashes($a['firstname']).'<br />';
$content .= ''.stripslashes($a['surname']).'<br />';
$content .= ''.stripslashes($a['email']).'';
}
echo $content;

 

My problem is, sometimes some of the data is repeated because the same name and email address has been stored in the database.  I would like the above script to show all the data but if it finds a repetition to not display it.

 

I hope the above makes sense and you are able to help!

 

Thanks

[Mchl]

Wouldn't more logical approach be to remove duplicate entries from database?

[zenag]

use  distinct(name)  or group by name in select statement

[Bricktop]

Thanks zenag, got it working brilliantly with DISTINCT - forgot all about the DISTINCT syntax!

 

Thanks also for your reply Mchlm.