How to make a query to show duplicated row by a field

hello,

this is my query.

$query = "SELECT id, title, description FROM web ORDER BY list_number DESC LIMIT $start, $limit";

PHP:

how can i display only the fields which has got the same information on list_number?


thanks

 

Use GROUP BY. I'm not sure what you wanna do exactly.. try explaining a bit better

 

i think you mean:

SELECT .. FROM web WHERE list_number = 2 ..

2 is the list number your want all the records for

 

You may want to see only duplicate row by title and description.

I hope this will help you.

 

Very hard to understand what your looking for, but .. You can always use WHERE statement !

 

ok...

this is the database

id title description list_number

1 fjgh ritururgrf 2234
2 ooiyt googorg 314
3 weerrddd fdfdfdf 344533
4 aqwwsd oopthgh 314


I only want to display dublicate entries on list_number. So the output must be:

id title description list_number


2 ooiyt googorg 314
4 aqwwsd oopthgh 314

Thanks

 

$qry = mysql_query("SELECT id, title,description,list_number FROM table1 GROUP BY id, title,description,list_number HAVING COUNT(list_number) >1")

PHP: