Mysql timing out.

[xdentan]

My scripts that I am using seem to time out when they are almost done and give the error

You have an error in your SQL syntax near 'ok'ticheck'' at line 1

I am not sure what this means as I have no columns like this, or no entries like this.

[richie]

Can you run any query successfully ever? Do you get the same error no matter what database you use?

[Roger_Ramjet]

Post the code.

[xdentan]

<?
include "../includes/collegare.php";
$value = mysql_query("SELECT `username` FROM `variables`");
$num_rows = mysql_num_rows($value);
$start = 0;
mysql_query("UPDATE `variables` SET `turns` = `turns` + '3'");
mysql_query("UPDATE `variables` SET `turns`= `turns` + `timemachine`");
mysql_query("UPDATE `variables` SET `unsoliders`=`unsoliders` + `millitarybase`");
while($num_rows > $start){
$username = mysql_result($value, $start);
$_SESSION["usernamesecure"] = $username;
include "../includes/net.php";
include "../includes/newgold.php";
$average = $netattk + $netdef;
$average = $average * 6;
$gold = $gold / 100;
$average = $average + $gold;
$result = mysql_query("SELECT `turns` FROM `variables` WHERE `username`='$username'");
$turns = mysql_result($result, 0);
if($turns > 250){
mysql_query("UPDATE `variables` SET `turns`='250' WHERE `username`='$username'");
}
mysql_query("SELECT `gold` FROM `variables` WHERE `username`='$username'");
$gold = mysql_result($result, 0);
$gold = $gold + $final;
mysql_query("UPDATE `variables` SET `average` = '$average' WHERE `username` = '$username'");
mysql_query("UPDATE `variables` SET `gold` = '$gold' WHERE `username` = '$username'");
$start ++;
}
?>

everything seems to go ok except the last few users dont seem to get the gold. (the included files dont output errors, so somehwere in this file the error is being generated)