Adding Selected Fields in mySQL - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

airoid · 12-12-2005, 05:56 PM

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?

pairbrother · 12-13-2005, 01:57 PM

Code:

select sum(titles) from tablename where userid = '104'

If it was MS SQL/Oracle, this would have worked, try the same on mySQL, if it doesnt work, read the documentations