[SOLVED] Need help with PHP/MySQL count

[SocomNegotiator]

Well I am trying to count all of one field in a table. There could be 50 or more rows with different credit amounts...well I want the sum of all of them together. I know this is probably pretty basic, but I can't figure it out.

 

Here's what I have:

$credit_total=mysql_query("SELECT COUNT(credit_amount) FROM credits");
$row = mysql_fetch_assoc($credit_total);
$row['COUNT(credit_amount)']  = $count;

 

Now $count for some reason is just showing up as nothing

 

Any ideas?

[zenag]

SELECT SUM(credit_amount) FROM credits

[SocomNegotiator]

So then you would call that by saying

 

$row['SUM(credit_amount)']

 

or

 

 

$row['credit_amount']

[moon 111]

Change the query to:

 

SELECT SUM(credit_amount) AS credit_amount FROM credits

 

and use $row['credit_amount'].

[zenag]

$row['SUM(credit_amount)']

[SocomNegotiator]

That worked like a charm thank you very much!!!!

[SocomNegotiator]

SELECT SUM(credit_amount) AS credit_amount FROM credits

 

That worked like a charm thank you very much!!!!