如何通过选择发送两个值？

Question

I want to send the name and id field through the option tag. Right now as it is set up it is only sending id, how can send name as well to insert it in the data base?

<select name="category_id" size="1"><br />';

$sql = "SELECT id, name 
          FROM categories 
      ORDER BY name";

$rs = mysql_query($sql);

while($row = mysql_fetch_array($rs)) {
  echo "<option value=\"".$row['id']."\">".$row['name']."</option>
  ";
}

echo'
</select>

Answer 1

Make the option value have this format: name$id

<select name="category_id" size="1"><br />';

    $sql = "SELECT id, name 
              FROM categories 
          ORDER BY name";

    $rs = mysql_query($sql);

    while($row = mysql_fetch_array($rs)) {
      echo "<option value=\"".$row['name']."$".$row['id']."\">".$row['name']."</option>
  ";
    }

    echo'
</select>

then when you retrieve the data you can explode it as so

$option = explode("$", $_POST['category_id']);
echo $option[0]; // Name
echo $option[1]; // Id