how to set a status
Posted
by ejah85
on Stack Overflow
See other posts from Stack Overflow
or by ejah85
Published on 2010-03-18T15:28:51Z
Indexed on
2010/03/18
15:31 UTC
Read the original article
Hit count: 290
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..
© Stack Overflow or respective owner