Using dropdowns to query MySQL

[odin365]

I am a noob.

I am trying to create functionality like the customized search on the University of Maine Summer Session website: http://studentrecords.umaine.edu/soc.htm

I have all my data on a MySQL database. My issues is using the drop-downs as a query mechanism and pulling up the data. Despite all the PHP books in front of me, I am lost. One of my books recommends doing the drop downs in Javascript with hidden fields... accessing the php script that is a separate file on the server (I actually did something similar).

Thanks in advance.

[HuggieBear]

Something like this would work, just replace the database column and form fields with the names you require.

[code]<?php
// Connect to the database
include('connect.php');

// Query the database to get the values for the dropdown
$sql = "SELECT id, name FROM menu_options";
$result = mysql_query($sql);
if (!$result){
  echo "Unable to execute $sql<br>\n" . mysql_error(); // Error if we got no result
}

// Start the select menu
echo "<select name='menu_name'>\n";

// Echo each option of the menu
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
  echo "<option value='" . $row['id'] . "'>" . $row['name'] . "</option>";
}

// End the menu
echo "</select>";
?>[/code]

Regards
Huggie

[odin365]

Thank you Huggie! Sorry for not getting back sooner. I am still trying resolve a few things, but this got me going in the right direction.