[SOLVED] Best way to Count

[JSHINER]

I have a "views" field in my table for each record. Looks something like this:

 

ID | Views

-------------

1  |  20

2  |  50

3  |  30

 

What is the best way to display: "Total Views: 100"

[only one]

mysql_query("SELECT * FROM `table` ORDER BY `field` DESC LIMIT 100");

[JSHINER]

Maybe I wasn't clear?  ???

 

I want it to count the total "views" in the table. 20 + 30 + 50 = 100

[only one]

oh, i wouldn't do what you are doing the way you are

 

Add a new row for every view with the id of the thing it's on, then just use the mysql_num_rows() function.

[Orio]

<?php

$sql = "SELECT SUM(Views) as 's' FROM table_name";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
echo "Total views: ".$row['s'];

?>

 

 

Orio.

[lewis987]

hmm... try this:

<?PHP
$SQL = "SELECT * FROM `table`;";
$Q = mysql_query($SQL);
if($Q){
$i = 0;
while($views = mysql_fetch_assoc){
 $num[$i] = $views['views'];
 $i++;
}
$total = count($num);
$i = 0;
$outcome = 0;
while($i < $total){
 $outcome = $num[$i] + $outcome;
}
echo($outcome);
}else{
echo('NOTHING TO SHOW');
}
?>

 

there is probably an easier way to do it, but thats the way i'd do it.

 

hope it helps

[JSHINER]

Would a new row for each view be the best way to do this in terms of speed and resources used?

[lewis987]

no, the best way would make one row with just the views in it.

[Orio]

The best way is to use SQL's sum() function, just as I showed a few posts above.

 

Orio.

[only one]

Would a new row for each view be the best way to do this in terms of speed and resources used?

 

Yes.

[Orio]

Would a new row for each view be the best way to do this in terms of speed and resources used?

 

Yes.

No

This way you will have a very large table, that means alot of wasted disk space...

 

Orio.

[JSHINER]

Orio your method worked great thanks!