Codezwiz >> Forums >> General PHP Nuke Help >> sql help

is it possible to count how many times some data appears in my sql database.

for example:-

name age address
natalie 17 magni road
jasper 18 rainbow drive
karen 17 park square
keith 17 riverside park

i am wondering if i could do a count on the age,
17 shows up 3 times.

also could you do this with member id

for example

member id member name age address referral
1 natalie 17 magni road 2
2 jasper 18 rainbow drive 1
3 karen 17 park square 2
4 keith 17 riverside park 2

.....when some one if referred the member id is automactically filled in on the form and goes to the database. i am wondering is it possible in the account area put some code in to tell the member how many referrals they have had..basically do a count on the referral and displaying it in their account. sorry if this doesnt make sense i am finding it hard my self to understand

I'm a total newb at this stuff, but I believe you can just do a "SELECT" statement. For example (taken from the mySQL online manual):

mysql> SELECT t1.name, t2.salary FROM employee t1, info t2 WHERE t1.name = t2.name;

The first one

SELECT COUNT(age) AS total FROM table_name WHERE age = '17';

That would return the amount of times the number 17 is used in the age field.

The second one, i would need a better explanation.