// This took me a while to suss out. But the following code will produce a drop down menu based on the fields in your database (obviously you will need to change some of the fields for your database) and will then forward you to a results page depending upon your slections.
//The code for the results page is below as well
// Please include a link back to this site http://www.stevesims.com/scripts.htm so that others can benefit from this script
--------------------------------------------------------------------------------------------------
The Drop Down Menu code
--------------------------------------------------------------------------------------------------
-------------------------------------------------------
The Results Page (called srchtest1a.php in this example)
-------------------------------------------------------
";
echo "
| URL |
Area |
Town |
Post Code |
";
while ($r = mysql_fetch_array($result)) { // Begin while
$areas = $r["areas"];
$towns = $r["towns"];
$zip = $r["zip"];
$id = $r["id"];
echo "
| View Property |
$areas |
$towns |
$zip |
";
} // end while
echo "
";
} else { echo "problems...."; }
} else {
echo "Search string is empty.
Go back and type a string to search";
}
?>
|
-------------------------------------------------------------------------------------------
The individual page (in this example view2c.php)
-------------------------------------------------------------------------------------------
| $title |
![](\"../Houses/images/$images\") |
| $news |
Contact $author for further information.
This house was placed on the market on: $date |
";
}
?>
--------------------------------------------------------------------------------