Do u know how to return the sum of all rows entered ?

[taqi786]

What I want 2 ask is that

IF there is a way that i can count no. of rows of "MYSQL database table's column"

for example: I made a table "contacts" -------->with fields "name" "email"

When some1 filled a form

Name --------> XYZ
email ---------> some1@smethng.com

It sum up how many time xyz filled this form and show result like this

----------------------------------
Name / email / no. of times
xyz / some1@somethng.com 8
abc/ maths@science.com 8





Anybody has any suggestions

[chazzy]

maybe something like


select name, email, count(*) from your_table group by name, email