$credit_value) {//enough credit // discard credit form your credit $phoneNumber = $_SESSION['phoneNumber'] ; $query = "SELECT * FROM `user_information` WHERE `cus_num` = $phoneNumber "; $result = mysql_query($query); $row = mysql_fetch_array($result); $my_credit = $row['Credit']; $discarded_credit = $credit_value; $my_new_credit = $my_credit - $discarded_credit ; $update_query = "UPDATE `user_information` SET `Credit`= $my_new_credit WHERE `cus_num` = $phoneNumber "; $update_credit = mysql_query($update_query); // update others credit $query = "SELECT * FROM `user_information` WHERE `cus_num` = $transfer_to "; $result = mysql_query($query); $row = mysql_fetch_array($result); $his_credit = $row['Credit']; $his_new_credit = $his_credit + $credit_value ; $update_query = "UPDATE `user_information` SET `Credit`= $his_new_credit WHERE `cus_num` = $transfer_to "; $update_his_credit = mysql_query($update_query); if ($update_his_credit) { // transfer done . echo "

"."Transfer Complete

"; } }else{ // not enough credit echo "

"."You Don't Have Enough Credit

"; } }else{ // user is not founded echo "

"."Number is not Available

"; } }else{ echo "

"."Enter Numbers Only Please

"; } }else{ echo "

"."Please Enter Phone Number And Credit value to complete the credit transfer

"; } } ?>

Credit Transfer

Enter Number 0
Enter The Value