I have an option menu setup. echo "Current Status: <select name=status><option name=p>Paid</option><option name=np>Not Paid</option>
<option name=nd>Not Due</option></select></p>";
Now i want it to inset into the datase what the option says.
For example if "Not Paid" is the option I want it to inter Not Paid into that database field. Well my code is not working..
$sql = "UPDATE customers set status='$np' where cname='$cname'";
Anybody have an idea?
Thanks
Anthony
<option name=nd>Not Due</option></select></p>";
Now i want it to inset into the datase what the option says.
For example if "Not Paid" is the option I want it to inter Not Paid into that database field. Well my code is not working..
$sql = "UPDATE customers set status='$np' where cname='$cname'";
Anybody have an idea?
Thanks
Anthony