Pulldown menu selection to form

[rfigley]

Inserting this pulldown menu script to provide selections from a database field in a form to submit to the database . However I need the result of the selection to be sumitted with the rest of the data in the form to the database. As it is, none of the other data is being submitted either.

<form action="new_entry2.php">
<table width="406" border="0">
<tr>
<td width="128"><b>Name:</b></td>
<td width="268">
<input type="text" name="name2" size="40" maxlength="40">
</td>
</tr>
<tr>
<td width="128"><b>Chapter:</b></td>
<td width="268">

 <?


 include('dbconnect.php');
 include('font_setting2.htm');

 $query = ("select * from tbl_chapter");

$result = mysql_query($query) or die("Query fail");

if (mysql_num_rows($result) == 0)
{

} else
{

   //echo "<B> Current Chapters List </B>";
     echo  "<select name='select'>";

  while($row = mysql_fetch_array($result))
    {
        echo "<option>" . $row['chapter_name'] . "</option>";

       }

}                  

  ?>

<tr>
<td width="128"><b>Category:</b></td>
<td width="268">
<input type="text" name="category2" size="40" maxlength="40">
</td>
</tr>

[Weedpacket]

Well, if the HTML generated by the form display page is correct, then the problem isn't there, but in the processing script - new_entry2.php.

Are you using $_GET['name2'] etc. to refer to your form variables there?

[rfigley]

No, here's what is for new_entry2.php

<?php
include ("dbconnect_test.php");



   $sql = "INSERT INTO tbl_members (name,chapter,position,category,business_name,address1,address2,city,state,zip,phone,fax,e_mail,web_address) VALUES ('$name','$chapter','$position','$category','$business_name','$address1','$address2','$city','$state','$zip','$phone','$fax','$e-mail','$web_address')";

  $result = mysql_query($sql);


   include ("members_list.php");
?>