Match two entires from a query result

[brob]

I'm pulling a query from a database and want to check to see if there are any duplicates.

 

I don't want to remove the duplicates but display the id of them.

 

Does anyone know how to do this?

 

Thanks

[Balmung-San]

Well, to check for duplicates I'd use mysql_num_rows. As for displaying the id, a loop through them is the only method I know about.

 

<?php
//connect...
//query
if(mysql_num_rows($result) > 1)
{
//display ids
while($data = mysql_fetch_array($result))
{
echo $data['id'];
}
}
else
{
}
?>

[phat_hip_prog]

Here's a little ref, look at the replies:

http://uk2.php.net/manual/en/function.array-unique.php