php - Insert in one table and delete from another simultaneously -

<?php include("conn.php"); ?> <?php $name=$_post['name'];  $fathers_name=$_post['fathers_name']; $gotra=$_post['gotra']; $image=$_post['image']; $village=$_post['village']; $company_name=$_post['company_name']; $address1=$_post['address1']; $address2=$_post['address2']; $city=$_post['city']; $pincode=$_post['pincode']; $mobile1=$_post['mobile1']; $mobile2=$_post['mobile2']; $village_number=$_post['village_number']; if($_post['add2']) { $i=mysql_query("insert members_data values(null,'".$name."','".$fathers_name."','".$gotra."','".$image."','".$village."','".$company_name."','".$address1."','".$address2."','".$city."','".$pincode."','".$mobile1."','".$mobile2."','".$village_number."')");  $res=mysql_query("select image temp_members_data 'image' = '$image'"); $row=mysql_fetch_array($res); mysql_query("delete temp_members_data 'image' = '$image'");   } ?>   <script type="text/javascript">window.location="admin_approve.php"</script> 

i need in inserting in 1 table , deleting table clicking add button. adding in main table , deleting temp table. please help

"you must have 50 reputation comment" >.<

are wanting move data 1 table table? on database database? need clarify little bit more on trying do. have kind of primary key use instead of using image? (or rather image patch). understanding want move 1 table another. if case: need delete data in temp_members_data or nice have? if it's latter, try this:

insert new_members_data select * old_members_data image = '$image'"