$mainquery = mysql_query("SELECT id,level,charclass,spells FROM $users ORDER BY id"); while ($mainrow = mysql_fetch_array($mainquery)) { $level = $mainrow["level"]; $charclass = $mainrow["charclass"]; $newspell = $levels[$charclass][$level]; $newquery = mysql_query("UPDATE $users SET spells='$newspell' WHERE id='".$mainrow["id"]."' LIMIT 1"); if ($newquery != true) { $errors++; $errorlist .= mysql_error() . "<br />"; } }
and if i upgrade that he say the error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/krivel5.freehostia.com/mang/upgrade_to_112.php on line 334 Error upgrading Users table.
.. I have no idea what you are doing or what is going on. What the hell are you doing? Why dont you start from scratch. Delete everything, create a new table, update the config file and run install.php again.