[SOLVED] No Errors, but It Still Doesn't Work :(

[jj20051]

I have a video website script that I'm modifying. I'm attempting to count the total number of video views that a user gets and then print it out. Each video is stored in the database with the number of views it's received. Bellow is my code, $id refers to the user's username... There are no errors, so I don't know what is wrong. The output is just "Views:" it should be "Views: 37" as I have manually done the math.

 

The Table Name Is: video

Some Collums In That Table: videoid, username, views

 

// Retrieve all the data from the table
$result = mysql_query("SELECT SUM(views) FROM video WHERE username = '$id'")
or die(mysql_error());  

// store the record of the table into $row
$row = mysql_fetch_array( $result );
// Print out the contents of the entry 

echo "Views: ".$row['views'];

[Northern Flame]

what number is exactly in the column views

[jj20051]

There are 5 Rows ATM. In order the values are: 4, 15, 8, 5, 4.

 

As more videos are added this will increase and I only want it to add together a single user's total video views. (whoever is logged in and viewing this page)

[Northern Flame]

you can give this a try:

 

$result = mysql_query("SELECT SUM(`views`) FROM `video` WHERE `username` = '$id'")
or die(mysql_error());  

 

if that doesnt work,

display the exact setup of your table

[jj20051]

Still didn't work.

 

Here is the table with all rows (screenshot):

 

http://www.paydayvideos.com/errors.png

[jj20051]

Any Ideas anyone? I'd love some help.

[xtopolis]

Well, have you tried pasting the query in your code directly in your phpMyAdmin?

 

I'm fairly certain you need a GROUP BY clause to go with your sum...

SELECT SUM(views) FROM video WHERE username = 'admin' GROUP BY username

[jj20051]

Well, I typed it into phpmyadmin, and it came back as 38, which is the correct answer. So now it's just figuring out what's wrong with my php code and why it isn't printing.

[jj20051]

Got it thanks...