[SOLVED] PHP Subtraction Problem.

[chmpdog]

Hey,

 

Recently I was creating a script where it would pull off a number from the mysql server, then subtract one from it, then update the mysql number. But I keep getting a problem when I try: it returns '-1' each time the script runs

 

I have been trying to figure this out for about two hours now, Thanks for the help.

 

Here is the code:

$cur = mysql_fetch_array($resulm, MYSQL_ASSOC); // put the data in an array that we pull off the server

 $number = $cur[usernum];
$number = $number - 1;

    $q = "UPDATE "row" SET thenumber = '$number' WHERE id = '1'";
    mysql_query($q, $database->connection);

[genericnumber1]

try

 

<?php
   $number = (int)$cur['usernum'];
   $number = $number - 1;
?>

[chmpdog]

Nope. It still goes to -1. 

[genericnumber1]

then try enabling E_ALL error reporting, it's likely that $cur['usernum'] isn't set.

 

echo the variable to make sure it's set before subtracting one...

[chmpdog]

You were right. Thanks. 

 

All I had to do was include

global $cur;