Не ъпдейтва таблицата

[freboy]

<?
session_start();
$sesusername = $_SESSION['name'];
$query = mysql_query("SELECT * FROM users WHERE name = '$sesusername'");
$my = mysql_fetch_array($query);
$namepro = $my['namepro'];

$do = $_POST['do'];
$kod = $_POST['kod'];
$ip = $_SERVER['REMOTE_ADDR'];
$pref = getpoints;
if ($do)
{
$http = new clsHTTP();
$http->getPage("http://wisdom.bg/smscheckcode.php?prefix=$pref&code=$kod&user_ip=$ip");
$var = unserialize($http->getContent());
$http->getPage("http://wisdom.bg/smscheckcode.php?prefix=$pref&code=$kod&mark_as_used=1&user_ip=$ip");
$res = $var['result'];





if($res == "TRUE")
{

mysql_query("UPDATE `users` SET money='money+25000', sendsms='sendsms+1', maxnrg='200', namepro='1' WHERE `name` = '$sesusername'");


echo "<b>Успешно</b>";
}else{
echo "<b>Грешен код!</b>";
}
}
?>

 

[purko]

Пробвай като това
mysql_query("UPDATE `users` SET money='money+25000', sendsms='sendsms+1', maxnrg='200', namepro='1' WHERE `name` = '$sesusername'");


го замениш с това и кажи дава ли грешка
mysql_query("UPDATE `users` SET money='money+25000', sendsms='sendsms+1', maxnrg='200', namepro='1' WHERE `name` = '$sesusername'") or die(mysql_error());

Друг вариант е да ъпдейтваш полетата едно по едно т.е. вместо първото да го направиш така:

mysql_query("UPDATE `users` SET money='money+25000' WHERE `name` = '$sesusername'") or die(mysql_error());
mysql_query("UPDATE `users` SET sendsms='sendsms+1' WHERE `name` = '$sesusername'") or die(mysql_error());
mysql_query("UPDATE `users` SET maxnrg='200' WHERE `name` = '$sesusername'") or die(mysql_error());
mysql_query("UPDATE `users` SET namepro='1' WHERE `name` = '$sesusername'") or die(mysql_error());