Adding Selected Fields

[airoid]

I have a table in mysql with a "titles" column filled with a number and a "userid" column filled with the User ID. I am trying to add the values of all of the "titles" columns for a specific User ID. For example:

userid titles
104 2
125 1
104 5
182 3

I want to add the number of "titles" for userid 104. The output would be 7 (2+5). How would I do this?

[kayla]

Hi there;

Give this a try:

PHP Code:

<? $db = mysql_connect('localhost', 'username', 'password'); 

mysql_select_db('database_name'); 

$query = 'select * from this_table'; 
$query2 = 'select SUM(titles) AS qsum from this_table'; 
$result = mysql_query($query); 
$result2 = mysql_query($query2); 
$num = mysql_num_rows($result); 

$row = mysql_fetch_array($result2); 

// echo '<strong>'.$num.'</strong>'; 

echo '<p>Here are your results: '; 

echo '<strong>'.$row['qsum'].'</strong>'; ?>

hope it works for you