help with SUM()

[seany123]

all i wanna do is find a way to be able to use the result of this query so i can add and subtract from it.

 

 

$rcount = $db->execute("SELECT SUM(quantity) as '' FROM items WHERE id = '".$_POST['id']."'");

 

when i echo it gives me the correct value...

 

but when i try this:

 

$rcount = ($rcount + $_POST['quantity']);

 

it echo's  the result of ($_POST['quantity'] + 1)

 

can anyone give me help here please?

 

[ialsoagree]

We're definitely going to need more information. But here's a tip, in case you aren't aware. all $_POST data is of the string data type, that might play a role depending on what you're trying to add.

[seany123]

what more information is needed?

[ialsoagree]

Specifically...

 

Where does $_POST['quantity'] come from, what happens between your first posted line and your second posted line. Where are these echoes you refer to taking place?

[seany123]

This is an exact copy of that part of the script.

 

	if ($_POST['send2']){


	$rcount = $db->execute("SELECT SUM(quantity) as'' FROM items WHERE id = '".$_POST['id']."'");

	echo $rcount;

	$usrcount = ($rcount + $_POST['quantity']);

	echo $usrcount;

	echo $_POST['id'];

	echo $_POST['quantity'];

 

 

The $_POST comes from a form which is on the same page.

 

 

[shlumph]

Try casting both vars into an (int)

[seany123]

Try casting both vars into an (int)

 

in which way do you mean?

[shlumph]

$usrcount = (int)$rcount + (int)$_POST['quantity'];

[trq]

What database object is $db? What does $db->execute actually return?

[seany123]

What database object is $db? What does $db->execute actually return?

 

well im using adodb.

 

$db = &ADONewConnection('mysql'); //Connect to database
$db->Connect($config_server, $config_username, $config_password, $config_database);

 

and yes it does return.

 

$usrcount = (int)$rcount + (int)$_POST['quantity'];

 

no that didnt work. echo'd the same as if the (int) wasn't there.

[seany123]

any other ideas?

 

[ialsoagree]

and yes it does return.

 

The question wasn't "does it return?" it was "what does it return?"

[seany123]

well if i echo:

 

$db->execute

 

then it doesnt return anything.

[jl5501]

you have $rcount = $db->execute(.....);

 

immediately after that, put print_r($rcount), and you will see what it returns