[SOLVED] How to count columns not rows

[brooksh]

So what I'm trying to do is add all the counts up. So let's say you have in the database:

title: one count: 3

title: two count: 2

title: one count: 5

 

title: one should equal 8 for count.

$sql="SELECT title,count FROM data WHERE id='$id' GROUP BY title";
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());	

while($row = mysql_fetch_assoc($result))
{	
		$title=$row["title"];
		$count=$row["count"];
		$data[$title]=$count;
}

 

So something like this:

 

$sql="SELECT title,count FROM data WHERE id='$id' GROUP BY title";
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());	

while($row = mysql_fetch_assoc($result))
{	
		$title=$row["title"];
		$count=$row["count"];

}
foreach ($title AS $value)
{
$data[$title]=$count;
}

[sasa]

SELECT title, SUM(count) as count_sum FROM data WHERE id='$id' GROUP BY title