how to set a status
- by ejah85
hello guys..here i've a problem where i want to set the status whether it is approved or reject.. the condition are if admin select the registration number and driver name, that means the status is approve otherwise, if admin fill up the reason, that means the request is reject..
here is the code to set status
if ($reason =='null'){
$query2 = "UPDATE usage SET status ='APPROVED' WHERE '$bookingno'=bookingno";
$result2 = @mysql_query($query2);
}
elseif (($regno =='null')&&($d_name =='null')) {
$query3 = "UPDATE usage SET status ='REJECT' WHERE '$bookingno'=bookingno";
$result3 = @mysql_query($query3);
}
when i save the data, the status field are not updates..
