[SOLVED] A Bit Of Math

[cdog5000]

ok.. i have this here:

mysql_query("UPDATE authTable SET minerMinutesLeft=minerMinutesLeft+10000 WHERE username = '$username'");

but it only set's the minutes to 10000... i need some help plz

[tibberous]

That works. Either minerMinutesLeft isn't a number type, or it's 0, or your fucking it up somehow.

[cdog5000]

That works. Either minerMinutesLeft isn't a number type, or it's 0, or your fucking it up somehow.

no... it isn't working and i even made sure that it was working...and it's a type of int....

[unrelenting]

Have you looked in the database and verified what the integer is to begin with before 10000 is added to it?

 

Is the minerMinutesLeft column set as integer or do you have it set as a varchar or something?

[cdog5000]

Field  	                Type 	  Null  	Default
minerMinutesLeft  	int(11) No  	        1

[PFMaBiSmAd]

Add some error checking to get mysql/php to tell you if the mysql_query() is being executed without error -

 

mysql_query("UPDATE authTable SET minerMinutesLeft=minerMinutesLeft+10000 WHERE username = '$username'") or die("Update query failed: " . mysql_error());

[cdog5000]

Add some error checking to get mysql/php to tell you if the mysql_query() is being executed without error -

 

mysql_query("UPDATE authTable SET minerMinutesLeft=minerMinutesLeft+10000 WHERE username = '$username'") or die("Update query failed: " . mysql_error());

ok... i found out it was a simple syntax error in my username