Is there a better Way

[gilgimech]

I've got this bit of php code to call a sql query.

 

The query is for specific rows in my database. It adds the amounts together of the items in these rows.

 

This is what I have.

 

$plugins_sql = mysql_query("SELECT forum_posts FROM slave_forums");
$plugins_jQuery = mysql_result($plugins_sql, 4 );
$plugins_actionscript = mysql_result($plugins_sql, 2 );
$total_count = $plugins_jQuery ['COUNT(forum_posts)'] + $plugins_actionscript['COUNT(forum_posts)'];
$plugins_count = $total_count;

 

In total I'm gonna have to include 15 rows into this. It seems to work fine. I was just wondering if there was a better way of doing it.

 

[brianlange]

What does your table structure look like?