如何设置状态

Question

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..

Answer 1

You have your where clause formatted incorrectly, it seems. Change this:

$query2 = "UPDATE usage SET status ='APPROVED' WHERE '$bookingno'=bookingno";

to this:

$query2 = "UPDATE usage SET status ='APPROVED' WHERE bookingno='$bookingno'";

(for both $query2 and $query3).

See if that doesn't fix it.