Query then update mysql database

[AmandaArias]

Hi all! I have the following code which works:

if(isset($deletename)){ 

// create SQL statement  to get newbw
$thesql = "SELECT * FROM clients WHERE id='$clientid'";
$theresult = mysql_query($thesql);
$amandarow = mysql_fetch_array($theresult);
$variable = $amandarow["variable"];
//newvariable
$variablenew = $variable + $passed_in_url_variable;


//delete from anothertablename db
    $sql="DELETE FROM anothertablename WHERE username='$deletename'"; 
        if(@mysql_query($sql)){ 
        print("<DIV ALIGN=\"center\"><BR><BR><B>SUCCESS</B></DIV>"); 
        }else{print("Error deleting: mysql_error()"); 
         
        } 
    } 

What I need to do is add another sql statement to occur at the same time but on the clients table. I need it to update $variable with $variablenew.

Any ideas?

Thanks much!

Amanda

[PHP John]

Right now, with what I know, I would do this:

get data from the client table.

delete data from another table.

update data in the client table.

This would involve 3 separate queries.

[AmandaArias]

Thanks for the reply. So where within the code above would you stick the update query if you were me?

Amanda

[PHP John]

It really does not matter, as long as you do it BEFORE you require the updated information.

[AmandaArias]

Cool. I got it working. Thanks!

Amanda

[PHP John]

No problem!