Taking datas from mysql and increase it?

Dakkar

I have a problem about taking data from mysql(int) increase it 1 point and write it to mysql again i tried to write a code like this but it didnt work

<?
$a = "SELECT hata from counter where id = '1'";
$b = mysql_query($a);

if (($sub1 < 2) && ($sub2 < 2) && ($sub3 < 2)) {
@mysql_query("insert into accounts values('','$u_name','$pass','$name','$momname',NOW() + INTERVAL 90 DAY,NOW(),'$mail','0','0','0','0','0','0','0')");
 echo "<center><b>Bilgileriniz veritabanina kaydedildi.Tesekkurler.</b></center>";
} else {
$b++;
@mysql_query("update counter set hata='$b' where id='1'");
}
?>

where did i make mistake?

Weedpacket

$b is a MySQL result resouce, not a number.

But why not just write "update counter set hata = hata+1 where id='1'"?

PS. there are some tips on debugging MySQL queries in the "Debugging 101" thread in the Echo Lounge (e.g., echo the query out to see what it says, not using @ unless you really have to...).

Dakkar

Thanks it worked
Now i want to show this number (which is stored in hata column under counter table) in a web page
what must i do ?

I tried this

$a = "SELECT hata from counter where id = '1'"; 
$b = mysql_query($a);
$c = mysql_fetch_row($b);

echo "Total error is $c";

but when i use it its showing like this
Total error is array

if i write

echo "Total error is $b";
this time it is showing like this

Total error is resource id #4

where did i make mistake?

wilku

As $c is an array, try to check its first element like this:

echo "Total error is $c[0]";