在下拉菜单中选择名称的位置插入 ID - inserting id where chosen name from drop down menu

inserting id where chosen name from drop down menu

>我正在尝试将plan_name =（从选择中选择）的plan_id插入数据库

你能帮我弄清楚这个片段有什么问题

吗

<?php
$plan_id = ($a);
$query = "INSERT INTO tbl_reservation(cust_id, pack_type, plan_id, res_date, res_venue,     date_app) VALUES     ('{$cust_id}','{$pack_type}','{$plan_id}','{$res_date}','{$res_venue}',CURDATE())";
$result_set = mysql_query($query);
?>
<select name="plan_id">
<?php 
    $queryy = mysql_query("SELECT * FROM tbl_wed_plan");
    while ($row = mysql_fetch_array($queryy)){
    $plan_id = $row['plan_id'];
    echo"<option value='.$row[plan_name].'>$row[plan_name]</option>";
    }
    $a = '';
    if('plan_id' == 'Sho Minamimoto') {
    $a = 'plan-01';
    }else if('plan_id' == 'Janine Tugonon') {
    $a = 'plan-02';
    }else if('plan_id' == 'Jessie Jameson') {
    $a = 'plan-03';
    }else if('plan_id' == 'Karl Marx Bautista') {
    $a = 'plan-04';
    }
?>

连接问题。我想

echo"<option value='".$plan_id."'>".$row[plan_name]."</option>";

以下是更正后的代码：用户$plan_id而不是'plan_id'

<?php
$plan_id = ($a);
$query = "INSERT INTO tbl_reservation(cust_id, pack_type, plan_id, res_date, res_venue,     date_app) VALUES     ('{$cust_id}','{$pack_type}','{$plan_id}','{$res_date}','{$res_venue}',CURDATE())";
$result_set = mysql_query($query);
<?php 
    $queryy = mysql_query("SELECT * FROM tbl_wed_plan");
    while ($row = mysql_fetch_array($queryy)){
    $plan_id = $row['plan_id'];
    echo"<option value='".$plan_id."'>".$row['plan_name']."</option>";
    }
    $a = '';
    if($plan_id == 'Sho Minamimoto') {
    $a = 'plan-01';
    }else if($plan_id == 'Janine Tugonon') {
    $a = 'plan-02';
    }else if($plan_id == 'Jessie Jameson') {
    $a = 'plan-03';
    }else if($plan_id == 'Karl Marx Bautista') {
    $a = 'plan-04';
    }
?>