[Solved] I want to select and cont last week duplicate value from database [closed] January 11, 2023 by Kirat I think you can assign count() a name using AS so you can call it later SELECT country, COUNT( * ) AS total FROM grabber GROUP BY country So now you can print echo $row['total']; Then I would like you to remember that mysql_* functions are deprecated so i would advise you to switch to mysqli or PDO 0 solved I want to select and cont last week duplicate value from database [closed]