[Resolved] SELECT COUNT to get total

[kpowning]

I have a datbase table the has the following field in it: totalreferrals

I'm trying to count the total number from this field. How can I create this query to get the actual number count.

At this point there are 2 rows with information in this field - One row has the number (1) in it and another row has the number (3) in it. So basically I need a query that will count all these numbers and print out the correct count which would be (4) in this instance. I hope this makes since... Any help appeciated.

[leatherback]

I am not sure about this but..

Have you tried:

select sum(YourCol) 
from YourTable 
where YourSubSet

J.

[dud3r]

select your table then
$1 = $row['your row1'];
$2 = $row['your row2'];

$total = ($1 + $2);

and then call it with echo $total; or something.

[Roger_Ramjet]

You use an Aggregate function , in this case SUM() as leatherback has shown. No need to do it in code, dud3r.

[kpowning]

AWESOME it works.. Thx guys