[wambulance]

how do you add smething like <option value="">something</option> to every thing someone send into a mysql database. i want the value="" to have the same name as the name they type. so it would be like this

HTML Code:

<form action="insert.php" method="post">
<input type="text" name="name" />
</form>

then in insert.php i want to to send it as this.

PHP Code:

<option value="$_POST[name]">$_POST[name]</option> 

to the mysql database. i tried like this but it didnt work

PHP Code:

<?php

$con = mysql_connect("localhost","","");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }



mysql_select_db("DB", $con);



$sql="INSERT INTO tablename (name)

VALUES

('<option value='$_POST[name]'> $_POST[name]</option>')";



if (!mysql_query($sql,$con))

  {

  die('Error: ' . mysql_error());

  }

echo "Added!!!!";



mysql_close($con)

?>

any help please?