HTML : from select list need to add value to mysql

Question

I have an html drop down with some values like :

This one is inside form :

<b>Priority</b><select><name = "priority" id="priority"><option>Low</option><option>Medium </option><option>High</option></select>

Now when I click submit, What the value I select should be inserted to db. For that iadded like :

$priority = $_POST['priority'];
$sql3= "INSERT INTO work (priority) VALUES ('$priority')";

But it throw error : unknown identifier.

So how can I get the value from the select and insert into db. Pleasehelp

j08691 · Accepted Answer · 2012-03-15 20:00:47Z

2

Change:

<select><name = "priority" id="priority">

to:

<select name="priority" id="priority">

answered Mar 15, 2012 at 20:00

j08691

208k33 gold badges269 silver badges281 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1