drop down menu's in php

Anon

I am having 2 problems with drop down menus in PHP.

I have manged to successfully populate the drop down menus through an sql query

i.e:
<?php
while ( $row = ingres_fetch_object() ) {
echo "<OPTION VALUE=\"".$row->name."\">".$row->name."</OPTION>\n";
}

I am unable to add a submit button to this php so that it can go to the next page.

The second problem is that I am unable to put 2 or more drop down menus on the same PHP page, does anyone know why this could be or how I could place two drop down menus on the same page.

So could someone PLEEASE let me know:
1) How to submit data from the drop down menu.

2) How to put two drop down menus on the same php page.

Below I have included the full source code from the php page:

====================================

<body>

<?php
ingres_connect (sales,ingres,ingres) or die ("Could not connect");
print ("Connected successfully");
$sql = "select cpu_code from price order by cpu_code";

ingres_query ($sql);

<SELECT NAME="theselect">

<?php

while ( $row = ingres_fetch_object() ) {


echo "<OPTION VALUE=\"".$row->cpu_code."\">".$row->cpu_code."</OPTION>\n";
}

echo "</SELECT>"
?>

<?php

ingres_close ();

</body>

Anon

Your drop down needs to be inside a <FORM></FORM> tag. This will allow you to tell it where it needs to go when submitted, and to add a submit button.

ingres_query ($sql);
?>
<FORM action="mysubmitpage.php" method="POST">
<SELECT NAME="theselect">

<?php

while ( $row = ingres_fetch_object() ) {

echo "<OPTION VALUE=\"".$row->cpu_code."\">".$row->cpu_code."</OPTION>\n";
}

echo "</SELECT>";
echo "<INPUT TYPE=submit NAME=submit VALUE=submit>";
echo "</FORM>";
?>