Update SQL table php mysql -

i want update sql table. table name payment_all. didn't error database doesn't update. here php code.

    <?php $id=""; $opr=""; if(isset($_get['opr']))     $opr=$_get['opr'];  if(isset($_get['rs_id']))     $id=$_get['rs_id'];   //---update data---// if(isset($_post['btn_upd'])){     $semester=$_post['semtxt'];     $s_name=$_post['s_name'];     $reg=$_post['reg'];     $fa_name=$_post['factxt'];     $pay_name=$_post['papytxt'];     $totalpay=$_post['tptxt'];      $sql_update=mysql_query("update payment_all set                             semester='$semester' ,                             s_name='$s_name',                             reg='$reg' ,                             faculties_name='$fa_name' ,                             payment_name='$pay_name' ,                             tota_payl='$totalpay'                          payall_id=$id                      ");  if($sql_update==true)     $msg="update success..."; else     $msg="update fail!...";   } ?> 

my table field like

payall_id, stu_id, semester, s_name, reg, faculties_name, payment_name, total_pay, date.

please help.

try . specified wrong column name tota_payl

$sql_update=mysql_query("update payment_all set                             semester='$semester' ,                             s_name='$s_name',                             reg='$reg' ,                             faculties_name='$fa_name' ,                             payment_name='$pay_name' ,                             total_pay='$totalpay'                          payall_id=$id                      ");