sql 방금 업데이트 한 값 가져올 수 있나요? 채택완료

$sql_revenue_select = "SELECT * FROM g5_member_revenue WHERE mb_order = '$order' AND mb_id = '$id' AND in_quarter = '$in_quarter'";

                $sql_revenue_result = sql_query($sql_revenue_select);

                $sql_revenue_row = sql_fetch_array($sql_revenue_result);

 

               

               

               

 

                $result_revenue_update = sql_query("UPDATE g5_member_revenue SET give_ratio = '$revenue_ratio',

                this_revenue = '$this_revenue' , give_day = '$give_day'

               

                WHERE mb_id = '$id' AND in_quarter = '$in_quarter' AND mb_order = '$order' ", true);

 

                 

                  $sql_revenue_result = sql_query("SELECT * FROM g5_member_revenue WHERE mb_order = '$order' AND mb_id = '$id' AND in_quarter = '$in_quarter'");

                  $sql_revenue_row = sql_fetch_array($sql_revenue_result);

                 

                  if($sql_revenue_row['mb_order'] == 1){

                   $total_revenue = $this_revenue;

                   

                  }else{

                  $old_total = $sql_revenue_row['total_revenue'];

                  $total_revenue = $old_total + $this_revenue;

                 

               }

               $result_revenue_update = sql_query("UPDATE g5_member_revenue SET total_revenue = '$total_revenue' WHERE mb_id ='$id' AND in_quarter = '$in_quarter' AND mb_order = '$order' ", true);

               

            }

           

           

?>