total hits in my site sum()

[akreation]

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]

[shoz]

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]

[akreation]

works great! thanks!