Jump to content


Photo

total hits in my site sum()


  • Please log in to reply
2 replies to this topic

#1 akreation

akreation
  • Members
  • Pip
  • Newbie
  • 4 posts

Posted 09 June 2006 - 10:49 PM

I am trying to display the total hits on my web site. i have a column called hits in the table called mos_content. I want to total number from the hits column. this code is not working for me any suggestions?....



<?
mysql_select_db($database_sample, $sample);
$query_rs_hits_total = "SELECT SUM(hits) FROM mos_content "; 
$result = mysql_query($query_rs_hits_total) or die(mysql_error()); 
$sum_hits = mysql_fetch_array($result); 
?>

<?php echo $sum_hits; ?>



#2 shoz

shoz
  • Staff Alumni
  • Advanced Member
  • 600 posts

Posted 09 June 2006 - 11:02 PM

You should be able to use the following.
<?php
mysql_select_db($database_sample, $sample);
$query_rs_hits_total = "SELECT SUM(hits) FROM mos_content ";
$result = mysql_query($query_rs_hits_total) or die(mysql_error());
list($sum_hits) = mysql_fetch_array($result);
?>
Usually when you use a function in the column list you give it an alias to easily reference the column
eg:
mysql_select_db($database_sample, $sample);
$query_rs_hits_total = "SELECT SUM(hits) AS sum_hits FROM mos_content ";
$result = mysql_query($query_rs_hits_total) or die(mysql_error());
$row = mysql_fetch_array($result);
$sum_hits = $row['sum_hits'];
You can read through these two topics for more info on Mysql data retrieval..
[a href=\"http://www.phpfreaks.com/forums/index.php?showtopic=95441\" target=\"_blank\"]http://www.phpfreaks.com/forums/index.php?showtopic=95441[/a]
[a href=\"http://www.phpfreaks.com/forums/index.php?showtopic=95443\" target=\"_blank\"]http://www.phpfreaks.com/forums/index.php?showtopic=95443[/a]

#3 akreation

akreation
  • Members
  • Pip
  • Newbie
  • 4 posts

Posted 09 June 2006 - 11:10 PM

works great! thanks!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users