Display number of duplicates from database [SQL]

Question

This is my code.

$sqlcount = "SELECT count(*) AS C, Horse_ID FROM images WHERE Horse_ID = 24 GROUP BY Horse_ID HAVING COUNT(*) > 1 LIMIT 0, 30";

//echo $sqlcount;       

$resultcount = $conn->query($sqlcount); 

$rowcount = $result->fetch_assoc();

echo $rowcount['C'];

Why won't it echo the number 4, which is what shows when I test it in phpmyadmin? There are 4 duplicate values in that table hence the 4.

Danyal Sandeelo · Accepted Answer · 2015-05-10 20:08:43Z

2

 $rowcount = $result->fetch_assoc();

to

 $rowcount = $resultcount->fetch_assoc();

answered May 10, 2015 at 20:08

Danyal Sandeelo

12.4k10 gold badges57 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

halfer Over a year ago

@Charlotte: don't forget to accept this answer. To do so, click the tick mark to the left of the answer, so it turns green. This helps both the poster (they get a few internet points) and other readers (who see which was the preferred answer). Thanks!

Gordon Linoff · Accepted Answer · 2015-05-10 20:14:36Z

0

If you want the number of duplicates in the database, why not write the query to get that value?

SELECT COUNT(*)
FROM (SELECT count(*) AS C, Horse_ID
      FROM images
      WHERE Horse_ID = 24
      GROUP BY Horse_ID
      HAVING COUNT(*) > 1 
     ) i;

Then, you will only be returning one value from the database to the application (which is faster) and there is no need to artificially limit the count to 30.

answered May 10, 2015 at 20:14

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Collectives™ on Stack Overflow

Display number of duplicates from database [SQL]

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related