This is my code
Code: Select all
$add = 1;
$nbal = 1000;
if(isset($_POST['submit'])){
$bkcid=$_POST['publisher'];
$select = mysql_query("select * from users WHERE id = $bkcid");
while($row = mysql_fetch_array($select)){
$user_id1 = $row['id'];
$pbal1 = $row['balance'];
$lev1 = $row['level'];
$reff1 = $row['referral'];
$update2 = mysql_query("UPDATE users SET follower = follower + 1, balance= balance + 1000 WHERE id=$reff1") or die (mysql_error());
}
$seselect = mysql_query("select * from users WHERE id = $reff1");
while($row1 = mysql_fetch_array($seselect)){
$user_id2 = $row1['id'];
$pbal2 = $row1['balance'];
$lev2 = $row1['level'];
$reff2 = $row1['referral'];
$update3 = mysql_query("UPDATE users SET follower = follower + 1, balance= balance + 1000 WHERE id=$reff2") or die (mysql_error());
}
$tselect = mysql_query("select * from users WHERE id = $reff2");
while($row2 = mysql_fetch_array($tselect)){
$user_id3 = $row2['id'];
$pbal3 = $row2['balance'];
$lev3 = $row2['level'];
$reff3 = $row2['referral'];
$update4 = mysql_query("UPDATE users SET follower = follower + 1 , balance= balance + 1000 WHERE id=$reff3") or die (mysql_error());
}
$fselect = mysql_query("select * from users WHERE id = $reff3");
while($row3 = mysql_fetch_array($fselect)){
$user_id4 = $row3['id'];
$pbal4 = $row3['balance'];
$lev4 = $row3['level'];
$reff4 = $row3['referral'];
$update5 = mysql_query("UPDATE users SET follower = follower + 1, balance= balance + 1000 WHERE id=$reff4") or die (mysql_error());
}
$fiselect = mysql_query("select * from users WHERE id = $reff4");
while($row4 = mysql_fetch_array($fiselect)){
$user_id5 = $row4['id'];
$pbal5 = $row4['balance'];
$lev5 = $row4['level'];
$reff5 = $row4['referral'];
$update6 = mysql_query("UPDATE users SET follower = follower + 1 , balance= balance + 1000 WHERE id=$reff5") or die (mysql_error());
}
$siselect = mysql_query("select * from users WHERE id = $reff5");
while($row5 = mysql_fetch_array($siselect)){
$user_id6 = $row4['id'];
$pbal6 = $row5['balance'];
$lev6 = $row5['level'];
$reff6 = $row5['referral'];
$update7 = mysql_query("UPDATE users SET follower = follower + 1 , balance= balance + 1000 WHERE id=$reff6") or die (mysql_error());
}
$sevselect = mysql_query("select * from users WHERE id = $reff6");
while($row6 = mysql_fetch_array($sevselect)){
$user_id7 = $row6['id'];
$pbal7 = $row6['balance'];
$lev7 = $row6['level'];
$reff7 = $row6['referral'];
$update8 = mysql_query("UPDATE users SET follower = follower + 1 , balance= balance + 1000 WHERE id=$reff7") or die (mysql_error());
if ($update8){$mesg='<font color="white"> <strong> Member "$status" is Updated Successfully</strong> </font>'; }
}
}
please urgent help will be appreciated