[PHP] Storing/passing variables through multiple-part function/casestatement

[Verdon Vaillancourt]

Hi,

Iım trying to cobble together a case where where data is retrieved from one
row of a mySQL table, the row is deleted, the retrieved data is inserted
into a new row in different table. Most of my code seems to be working (I
think the data is being retrieved, the old row is being deleted, the new row
is being created) but I am not getting a grip on how to pass the retrieved
data into the sql insert statement for the new row in the second table. Iım
sure Iım missing something very basic and would appreciate any help
extended. The case statement as is now, is below.

TIA, verdon

Ps. Please cc me in any answer to the list as I am on digest mode

        case "finishPending":
        if ($user_dblocation)
        {
            @mysql_select_db("$user_dbname") or die ("Unable to select
database");
            
            $result = mysql_query("select uid, uname, name, url, email,
femail, pass, company, bio, description, address, city, province, postcode,
phone, fax, tollfree, otherphone, cat AS uid, uname, name, url, email,
femail, pass, company, bio, description, address, city, province, postcode,
phone, fax, tollfree, otherphone, cat from " . $table_prefix."users_que
where uid='$approve_uid'");
            list($uname) = mysql_fetch_row($result);

            mysql_query("lock tables " . $table_prefix."users_que WRITE");
            mysql_query("delete from " . $table_prefix."users_que where
uid='$approve_uid'");
            mysql_query("unlock tables");
            @mysql_select_db("$dbname") or die ("Unable to select
database");
        }
        else
        {
            $result = mysql_query("select uid, uname, name, url, email,
femail, pass, company, bio, description, address, city, province, postcode,
phone, fax, tollfree, otherphone, cat AS uid, uname, name, url, email,
femail, pass, company, bio, description, address, city, province, postcode,
phone, fax, tollfree, otherphone, cat from " . $table_prefix."users_que
where uid='$approve_uid'");
            list($uname) = mysql_fetch_row($result);
            
            mysql_query("lock tables " . $table_prefix."users_que WRITE");
            mysql_query("delete from " . $table_prefix."users_que where
uid='$approve_uid'");
            mysql_query("unlock tables");
        }

        mysql_query("LOCK TABLES " . $table_prefix."stories WRITE");
        mysql_query("UPDATE " . $table_prefix."stories SET
informant='$anonymous' WHERE informant='$uname'");
        mysql_query("UPDATE " . $table_prefix."stories SET aid='$anonymous'
WHERE aid='$uname'");
        mysql_query("UNLOCK TABLES");

        global $uid, $uname, $name, $url, $email, $femail, $pass, $company,
$bio, $description, $address, $city, $province, $postcode, $phone, $fax,
$tollfree, $otherphone, $cat;

        $sql = "insert into ".$table_prefix."users
(name,uname,email,femail,url,pass,company,bio,description,address,city,provi
nce,postcode,phone,fax,tollfree,otherphone,cat,conversionflag) values
('$name','$uname','$email','$femail','$url','$pass','$company','$bio','$desc
ription','$address','$city','$province','$postcode','$phone','$fax','$tollfr
ee','$otherphone','$cat','1')";
        
        if ($user_dblocation)
        {
            @mysql_select_db("$user_dbname") or die ("Unable to select
database");
            mysql_query("lock tables " . $table_prefix."users WRITE");
            $result = mysql_query($sql);
            mysql_query("unlock tables");
            @mysql_select_db("$dbname") or die ("Unable to select
database");
        }
        else
        {
            mysql_query("lock tables " . $table_prefix."users WRITE");
            $result = mysql_query($sql);
            mysql_query("unlock tables");
        }

        if (!$result)
        {
            echo mysql_errno(). ": ".mysql_error(). "<br />";
            return;
        }

        html_header_location("admin.php?op=adminMain");
        echo mysql_error();
        break;