I have a mysql table that looks like this:

id int(11) autoincrement
artist varchar(50)
title varchar(50)

I need to check for any rows that have the same titles.
So for example, if I had the following rows:

1 - Bob - Hello World
2 - Charlie Brown - Theme Song
3 - Joe - Hello World
4 - Joe - Is Cool
5 - Bob - Magic Dude

The query would display Row 1, and Row 3 as duplicates. Any idea how I can do something like this?

http://www.justin-cook.com/wp/2006/1...atabase-table/

Alright, I tried this:

PHP Code:

$result = mysql_query("SELECT title, COUNT(title) AS n FROM sheets GROUP BY title HAVING n > 1"); 


I have a while loop later on in my code that looks like this:

PHP Code:

while($row = mysql_fetch_array($result))[

} 


This is a page that I've been using for weeks and the while loop works great. There must be a problem with this query.

I am not getting any errors, nor anything displaying to the screen.

$result = mysql_query("SELECT title FROM sheets GROUP BY title HAVING count(title) > 1");

SELECT DISTINCT title FROM sheets GROUP BY title HAVING count(title) > 1