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

Filed under:
|

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

Related posts about php

Related posts about mysql