This is a nice and clean quick tip to create a jump menu without a "go" button. Say for example you have a list of items in a database that need to have a details page based upon their "id". This will create a dropdown menu that is auto populated with the most up to date list.
<?
// Connect to your MySQL database
require "path/to/your/database/connection/";
// Select the data
$select = mysql_query( "SELECT * FROM your_table_name ORDER BY column_name ASC") ord die("SELECT Error: ".mysql_error());
?>
// This is a bit of javascript to grab the value of the <option> selected
<select onchange="window.open(this.options[this.selectedIndex].value,'_top')">
<?
// Begin grabbing the rows from your database
while ($row = mysql_fetch_array($select)) {
?>
<option value="details.php?id=<? echo $row['id']; ?>">
<? echo $row['column_name']; ?>
</option>
<?
}
?>
</select>
Matthew A Price
^