PHP/MySQL C

[wiggst3r]

Hi

 

I have several rows in a datebase, each with a count field.

So rows have the following fields: id, friends_count, date

Row 1: 1, 4, 2008-11-19 00:00:00 

Row 2: 2, 5, 2008-11-20 00:00:00 

Row 3: 3, 1, 2008-11-21 00:00:00  etc

 

What I want to do, is loop through the database and get a total of the friends_count.

So the above rows would produce 10.

 

How would I do this?

 

Thanks

[revraz]

Look at the SUM function for MySQL.

[premiso]

SELECT SUM(friends_count) FROM tablename

 

Should do it.

[wiggst3r]

I used the following code:

 

			//Get total of vouchers from cached table
		$friends_cached = $db->db_query("SELECT SUM(total_friends) FROM daily_entries_cache");
		echo "Total Friends is $friends_cached";

 

And go the following error:

 

Total Friends is Resource id #12

 

What am I doing wrong?

 

Thanks

[premiso]

You need to mysql_fetch_row on the resource. Then access it by the index in the array [0]

[wiggst3r]

How would I access it?

 

My code is:

 

	$friends_cached = $db->db_fetch($db->db_query("SELECT SUM(total_friends) FROM daily_entries_cache"));

[trq]

The $db object you are using is not standard php. I would suggest reading the docs for that object or at least taking a look to see what its db_query() and db_fetch() methods return.