why aint this working?

[seany123]

i have this code:

 

$num = 250;
$count = ($num - $rcount);

echo $rcount;
echo "<br>";
echo $count;

 

when i echo $rcount it gives me 153...

 

so my calculations is 250-153 = 97.

 

 

but for some reason $count is echoing: 249.

 

 

anyone know what im doing wrong?

[Cardale]

   $num = 250;
   $count = $num - $rcount;
   
   echo $rcount;
   echo "<br />";
   echo $count;

[seany123]

   $num = 250;
   $count = $num - $rcount;
   
   echo $rcount;
   echo "<br />";
   echo $count;

 

that changed nothing.

[mrMarcus]

no, that wouldn't change anything.

 

post more of your code.  there is obviously something going on that you are not showing here, since this is just simple math.  you didn't even post the $rcount variable.

[seany123]

$rcount = $db->execute("SELECT SUM(quantity) as'' FROM items WHERE player_id = '$player->id'");

$num = 250;
$count = $num - $rcount;

echo $rcount;
echo "<br>";
echo $count;

[mrMarcus]

what does this give you:

 

$rcount = $db->execute("SELECT SUM(quantity) AS `count` FROM `items` WHERE `player_id` = '".$player->id."'");
   echo $rcount->count;

[dbillings]

try echoing $rcount before you perform the math.

 

   echo $rcount; // for testing purposes
   $num = 250;
   $count = ($num - $rcount);
   
   echo $rcount;
   echo "<br>";
   echo $count;
   

[Mark Baker]

$rcount = $db->execute("SELECT SUM(quantity) as'' FROM items WHERE player_id = '$player->id'");

$rcount is likely to be a resource (a database result) rather than an actual integer value. You need to read your value from the result set.

 

Why as''?

[seany123]

$rcount = $db->execute("SELECT SUM(quantity) as'' FROM items WHERE player_id = '$player->id'");

$rcount is likely to be a resource (a database result) rather than an actual integer value. You need to read your value from the result set.

 

Why as''?

 

because if not i get this echo'd "SUM(quantity) 153 "

 

try echoing $rcount before you perform the math.

 

   echo $rcount; // for testing purposes
   $num = 250;
   $count = ($num - $rcount);
   
   echo $rcount;
   echo "<br>";
   echo $count;
   

 

That just did nothing different.

what does this give you:

 

$rcount = $db->execute("SELECT SUM(quantity) AS `count` FROM `items` WHERE `player_id` = '".$player->id."'");
   echo $rcount->count;

 

that gave me no echo from $rcount.

[seany123]

scratch that.

[seany123]

this still isnt working and i havnt been able to find the problem anyone know?

[seany123]

Anyone got any ideas?

[seany123]

Okay so because nobody has been able to help me with this maybe if i ask i different question i might find more joy....

 

does anyone know how to add up all the values in a table.. example...

 

$query = $db->execute("SELECT quantity FROM items WHERE player_id='$player->id'")

$rcount = (all quantitys added together).

 

there is already this but its not allowing me to use it in a equation...

 

$rcount = $db->execute("SELECT SUM(quantity) AS `` FROM `items` WHERE `player_id` = '".$player->id."'");

 

[seany123]

IS NO ONE ABLE TO HELP ME HERE??....

 

anyone know any other forum where i can get some help?

[mrMarcus]

listen dude .. this is a free forum (free for you to seek help/advice), and the people with whom you seek advice, are volunteering their time/efforts/advice.  volunteering means, work for free.

 

so, there are several reasons why nobody is helping you.

 

1. your problem does not interest anybody.

2. you have no retainer on anybody, nor do you employ anybody here .. therefore, nobody ahs an obligation to help you.

3. perhaps you've just annoyed people by having made the last 6 posts in your own thread.  now it's a spite thing?

 

anyways, firing out an indirect threat as so, "anyone know any other forum where i can get some help?", might have worked on ones' mom as a child, but i don't believe that will raise any concern around here.

 

most of these guys know their stuff, and if asked nicely, they will help you.  if nobody responds to your thread(s), refer to points 1, 2, and 3 again.

 

and if you want something done sooooooo badly, perhaps coughing up a few buckos will spark some interest.  but as long as you're seeking free help, you have to be more patient than that. seriously.

 

$db->execute();

 

will return true on success, and false on fail.  so, right off the bat, you are going to get unexpected results as you have it.

 

regardless, you are setting SUM(quantity) AS ``  .. you cannot get the SUM of anything if you set its alias to nothing.

 

i'm assuming you're using ADODB?  i'm not familiar with it, but you can try this:

 

$rcount = $db->GetAll("SELECT SUM(`quantity`) AS `count` FROM `items` WHERE `player_id` = '".$player->id."'");

echo $rcount['count'];