Jump to content

Archived

This topic is now archived and is closed to further replies.

akreation

total hits in my site sum()

Recommended Posts

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?....


[code]

<?
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; ?>

[/code]

Share this post


Link to post
Share on other sites
You should be able to use the following.
[code]
<?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);
?>
[/code]
Usually when you use a function in the column list you give it an alias to easily reference the column
eg:
[code]
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'];
[/code]
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]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.