Transfer from one table to another.. Automaticly

[aktiwers]

Hi,

Can some one help me?

When a member joins my site, all his info goes to the "tmp" table. And when I Verify User from admin area, the info get moved to the "members" table. Now my script forget to transfer the Username, which results in, the member cant log in.

I believe the error should be in this peace of code:

//*******************************
elseif($b=="Verify User") {
extract($GLOBALS);
$rs1=mysql_query("select from temp where ID=".$HTTP_POST_VARS["id"]);
$arr1=mysql_fetch_array($rs1);

for ($i=1; $i<=13; $i=$i+1) {
$a[$i]=$arr1[$i];
}

$rs1=null;

$rs1=mysql_query("delete from temp where ID=".$HTTP_POST_VARS["id"]);

for($i=1;$i<=11;$i++) {
$temparr[$i]=$a[$i];
}
for($i=12;$i<=25;$i++) {
$temparr[$i]=0;
}
$temparr[22]=$a[11];
$temparr[26]=$a[12];
$temparr[27]=$a[13];

$query="insert into members(Name,Address,City,State,Zip,Country,Phone,Email,Password,PaymentDetails,ref_by,Level1,Level2,Level3,Level4,Level5,Level6,Level7,Level8,Level9,Level10,Leader,Total,Unpaid,Paid,IP,Date) values (";
for ($i=1;$i<=26;$i++) {
$query=$query . "'" . $temparr[$i] . "', ";
}
$query=$query ."'". $temparr[27] . "')";

    $rs=mysql_query($query);

$query="insert into subsdetails(CDate,RDate,UDate) values (
now(),
now(),
now()
)";
$rs=mysql_query($query);

$rs=mysql_query("select * from members where Email='".$a[8]."' order by ID desc");
$arr=mysql_fetch_array($rs);

$acountid=$arr[0];
$rs=mysql_query("update subsdetails set RDate='".date ( "Y-m-d h:i:s", mktime (date("h"),date("i"),date("s"),date("m"),date("d")+$membershipperiod,date("Y")))."' where ID=".$acountid);

    $rs=null;


if ($a[11]==0)
{

$rs=mysql_query("select * from members where Level1<'$forcedmatrix' and ID <>'$acountid' order by ID limit 0,1");

if (mysql_num_rows($rs)>0)
{
$arr=mysql_fetch_array($rs);
assignreferrals($acountid,$arr[0],0,1);
}
}
else {
$rs=mysql_query("Select * from members where ID=".$a[11]);

if(mysql_num_rows($rs)>0) {
$rsupdate=mysql_query("Update members set Total=Total+".$signupbonus." where ID=".$a[11]);
$rsupdate=mysql_query("Update members set Unpaid=Unpaid+".$signupbonus." where ID=".$a[11]);
$arr=mysql_fetch_array($rs);
if($arr[12]>$forcedmatrix-1) {
assignreferrals($acountid,newupline($acountid,$a[11]),0,1);
}
else {
assignreferrals($acountid,$arr[0],1,1);
}
}
else {
$rs2=mysql_query("select * from members where Level1<".$forcedmatrix." and ID <>'$acountid' limit 0,1");

$arr2=mysql_fetch_array($rs);
assignreferrals($acountid,$arr2[0],0,1);
}

Can anyone help me find that error? and currect it?

Thanks