simple if

[knuff]

Hi why dosent this work?

if($no==1){
	mysql_query("UPDATE testdb SET no=no+1");
 $nej = 0;
 }

If i hit the refresh button the value of $no is still 1 so testdb will be updated on more time.

$no becomes 1 when the user hit the submit button (hidden input with value of 1 is included)

cheers knuff

[cgraz]

put single quotes around your query.

mysql_query("UPDATE testdb SET no='no+1'");

That should fix it, but another thing you may want to try in the future is simply echoing code to see if that if is even getting evaluated the way you want.

if($no==1){
    mysql_query("UPDATE testdb SET no='no+1'") or die(mysql_error());
    echo "UPDATE part";
 $nej = 0;
 }

I also added the mysql_error (although the problem is probably you missing single quotes). But mysql_error is a handy tool to remember for future problems.

Cgraz

[knuff]

Ok, the problem isnt to store data i a row. The problem is when i have stored data in the row i cant change my variables to a diffrent value. Are we talking about same thing?

knuff.

[cgraz]

You make no attempt to change the value of $no after the update has been sucessfully made. It doesn't change itself.

If you want $no to change to a different number (other than 1 after the query has been executed), or just unset the variable, then do your UPDATE query then add

$no = "0"; // or whatever number you want it to equal

or unset $no

unset($no);

Cgraz

[knuff]

it was supose to say

if($no==1){
    mysql_query("UPDATE testdb SET no=no+1")
 $no = 0;
 }

i tried to unset($no) before and after the update, but it still dosent work.

knuff

[cgraz]

if($no == 1){
    mysql_query("UPDATE testdb SET no=no+1")
    $no = "0";
    echo "Variable No equals " . $no . "(should be 0)<br>";
    unset($no);
    echo "Shouldn't print anything after now " . $no . "<br>";
    $no = "0";
    echo "Now it should print zero " . $no . "<br>";
 }

What does this output?

Cgraz