Help Using IF Statement

golfinggod

Hi
Can Anyone also help me with this part of the code ?

I know that

$Siterating

does equal 1 so that is okay. The problem is that the if statement doesnt activate and update the field.

$Browsername = 'Admin';

/////////////////////////////////////////////////////////////		  

/////////////////////////////////////////////////////////////		  

/////////////////////////////////////////////////////////////		  

///// Step 4 Increment Based On Rating ////////////////

if ( $Siterating == 1 )

{

$Update = "Update credits set Credits = Credits + 1 Where Username = Admin"; 

$Result3 = mysql_query($Update); 

echo $Result3;

};

Thanks 🙂

bigdaddysheikh

The only value if $sitstring reaches is one that just put that as a tru fucntiong such as

if ($sitestring){ 

//code goes here 

}

Because i beleive that a value of one is a true statement. if that doenst work try $sitstring=="1"

Tell me if this helps

golfinggod

HI
I broke down the script to test just the update section. That didnt work either, can you check the syntax for me.


$Update = "Update credits set Credits = Credits + 1 Where Username = Admin"; 

$Result3 = mysql_query($Update);

Thanks

bigdaddysheikh

$Update = "Update credits set Credits = Credits + 1 Where Username = Admin";

Normally when i do this i keep everything seperated.

Trying getting the new credits value out the side the box
is admin a variable, if it is then you are inserting the variables the wrong way.

$new_credit=$credits+1;

$update="update credits set credits='$new_credit' where username='$admin' ";

Notice how insert the variable in the sql syntax.

tell me if this helps