What is wrong with this small piece of code?!

[wickedneat]

What is wrong with this small piece of code?!

<?php 
$sql = "SELECT variable1, variable2, variable3, variable4, variable5, (variable1 + variable2 + variable3 + variable4 + variable5) AS total FROM table"; 
$result = mysql_query($sql);  $total = 0; 

while ($row = mysql_fetch_array($result)) {   
$total += $row['variable1 + variable2 + variable3 + variable4 + variable5']; 
}  

echo "Total: " . $total;  

or die("INSERT Error: ".mysql_error());
;
?>

[barbara1712]

Use this.

$total += $row['total']; 

[devbanana]

Using MySQL's SUM function, I think, would be a much better way of doing this.

But yes, you aliased your sum as the name total, so you use total.

[wickedneat]

I keep getting a blank page when I do that

[wickedneat]

My new code is the following, but I get a blank page

 <?php $sql = "SELECT variable1, variable2, variable3, variable4, variable5, (variable1 + variable2 + variable3 + variable4 + variable5) AS total FROM table"; $result = mysql_query($sql);  $total = 0;  while ($row = mysql_fetch_array($result)) {    $total += $row['total']; }    echo "Total: " . $total;    or die("INSERT Error: ".mysql_error()); ; ?>

[devbanana]

You want to put the or die part after the query itself, not in the code afterwords. Also, perhaps you still need to use tha tSUM function?

Try the "or die" and see what MySQL might complain about.

[wickedneat]

It should something that time, but it didn't add the numbers together.

[devbanana]

Did you put the or die statement after your mysql_query() to see if MySQL is giving an error? That's what I was trying to say in my last post.

[Chousho]

Some interesting reads that might help
http://dev.mysql.com/doc/refman/5.0/...l#function_sum
http://www.tizag.com/mysqlTutorial/mysqlsum.php
http://forums.devarticles.com/mysql-...tion-4804.html

[wickedneat]

Yes I did, but it didn't die. It says Total: 0 but, it should be 24 as it should have added the numbers.

[wickedneat]

I may need to select from a user variable two so it knows where to look to caculate it. That may be the problem, but I am not sure how to add that in there.

[devbanana]

You're sure that the table has rows?

And again, why aren't you using SUM? You've consistently refused to answer that...SUM is there for a purpose. Someone above even linked to the documentation.

[wickedneat]

I don't understand the Sum concept.. I'm not sure the syntax for it either.

here is my updated code, that doesn't work still:

<?php 
mysql_select_db(time_com, $connection);

$sql = "SELECT monreghours0, monreghours1, monreghours2, monreghours3, monreghours4 AS total FROM table WHERE username='$_SESSION[user_name]'"); 
$result = mysql_query($sql);  

$total = 0; 
while ($row = mysql_fetch_array($result)) {   
$total += $row['total']; 
}  

echo "Total: " . $total;  

?>

[devbanana]

Now you're just aliasing monreghours4 to total, which I'm assuming you don't want to do?

Please explain exactly what you are trying to add together.

As for the syntax of SUM, Chousho linked to the MySQL documentation above.

[wickedneat]

Okay, I have a form that a user fills out.. when they fill out that form data gets placed into different rows monreghours0, monreghours1 etc are column names.. I need to add these numbers together dependant on the user that row corresponds to.

[wickedneat]

Also, I am not sure what to put in places in says (sum), in regards to the syntax for SUM

[devbanana]

OK how about

SELECT monreghours0 + monreghours1 + monreghours2 + monreghours3 + monreghours4 AS total FROM table WHERE id = ...

You should use the user ID in the where clause instead of username, probably.

[wickedneat]

still a blank screen.

[devbanana]

OK listen...where you have

$result = mysql_query($sql); 

As I said before, you need to do:

$result = mysql_query($sql) or die(mysql_error()); 

Then it should tell you if you have an error.

[wickedneat]

I added that line in, it still a blank page it tells me nothing.

[spikeZ]

$sql = 
	"SELECT 
		sum(monreghours0 +
		monreghours1 +
		monreghours2 + 
		monreghours3 + 
		monreghours4) AS total 
	FROM 
		table 
	WHERE 
		username='". $_SESSION['user_name'] ."'
	");

try that

[wickedneat]

here is updated code:

<?php
mysql_select_db(time_com, $connection);

$sql = "SELECT monreghours0, monreghours1, monreghours2, monreghours3, monreghours4 AS total FROM table WHERE id ='$_SESSION[user_name]'");
$result = mysql_query($sql) or die(mysql_error());

$total = 0;
while ($row = mysql_fetch_array($result)) {
$total += $row['total'];
}

echo "Total: " . $total;

?>

[wickedneat]

I'm still getting a blank page with that spike, and it's providing me no error message.

[php_daemon]

If that's all of your code, you're not connecting to the db, and using an undefined constant time_com.

If that's not all of your code, place this on top of your script to turn on the error reporting:

ini_set('display_errors', 1);
error_reporting(E_ALL);

[wickedneat]

I've defined the $connections variable at the top of the document.