[SOLVED] Can someone check my code?

[Epidemic]

Hello,

 

I have recently done this script for my authentication script I am making.

 

$scriptname=$item_name.'Min';
$myusername=$_COOKIE['userData'];
$mins=10000;
$sql="SELECT * FROM $tbl_name WHERE username='$myusername";
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);
$mytime=$rows[$scriptname];
$newtime=$mins + $mytime;
$sql="UPDATE $tbl_name SET $scriptname='$newtime' WHERE username='$myusername'";
$result=mysql_query($sql);
header("location:thankyou.php");

 

If the item name is called cool, will my code add an extra 10,000 to the MySQL database in the collum coolMin of the username found from the cookie and then redirect to thankyou.php. I think it will work but it is for my PayPal IPN and I want to be sure and get some expert advice.

 

Thanks.

[abdfahim]

I dont know why you are writing so much. If i am not mistaken, you want to add 10000 to some column. Then it should go

$scriptname=$item_name.'Min';
$myusername=$_COOKIE['userData'];
$mins=10000;
$sql="UPDATE $tbl_name SET `".$scriptname."`=(`".$scriptname."`+".$mins.") WHERE username='$myusername'";
$result=mysql_query($sql);
header("location:thankyou.php");

[Epidemic]

Would that reset the number to 10000 or would it add 10,000.

 

 

However would my code work?

[DarkWater]

No, that'll add 10k to whatever in there.

 

[Epidemic]

Okay, Thank you very much