Jump to content


Photo

Adding the value of integers from MySQL database


  • Please log in to reply
2 replies to this topic

#1 xenooreo

xenooreo
  • Members
  • PipPip
  • Member
  • 11 posts

Posted 11 June 2006 - 12:42 AM

Alright, I'm thinking that the answer to this question is probably pretty easy [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /]


In my MySQL database, I have my content stored in a table called 'mainsite_main'. In that table there is also a column called 'hits' which keeps track of how many hits that particular item of content has had.

What I'm trying to do is select the entire column and add all the values together, to display the grand total amount of hits.


Thanks in advance for any help ^^

#2 shoz

shoz
  • Staff Alumni
  • Advanced Member
  • 600 posts

Posted 11 June 2006 - 01:12 AM

[a href=\"http://www.phpfreaks.com/forums/index.php?s=&showtopic=95479&view=findpost&p=382090\" target=\"_blank\"]http://www.phpfreaks.com/forums/index.php?...ndpost&p=382090[/a]

#3 xenooreo

xenooreo
  • Members
  • PipPip
  • Member
  • 11 posts

Posted 11 June 2006 - 01:18 AM

Thanks very much [img src=\"style_emoticons/[#EMO_DIR#]/laugh.gif\" style=\"vertical-align:middle\" emoid=\":laugh:\" border=\"0\" alt=\"laugh.gif\" /]




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users