Populate Mysql with a combination of Drop down menu's and text fields

programming
1

I’m trying to populate a MySQL table with a from that utilizes both text fields, and three drop down menu’s. The drop down menu’s are used for fields such as which state, counselor selection, and status (active, inactive, pending). The code i’m using for the form is a standard from:

<select name=“status” id=“status”>
<option>-------Please Select-------</option>
<option value=“Active”>Active</option>
<option value=“Pending”>Pending</option>
<option value=“Inactive”>Inactive</option>
</select>

In the php file that does the actual updating, it will update mySQL if everything is a text field. But since I added the drop down’s, it tells me “COULD NOT INSERT”. Everything from the form is posting as it should. The mysql query looks like this:

$query=“INSERT INTO clients VALUES(’’,’$id’,’$date’,’$fname’,’$lname’,’$employer’,’$address’,’$city’,’$state’,’$zip’,’$phone’,’$program’,’$counselor’,’$icredit’,’$status’)”;

Is there something I should know about drop down menu’s and mySQL?

Thanks,

Raithe Davion