[panqueconpasas]

I am pretty new to this (PHP & mySQL). I tried looking all over the hotscripts site but wasn't quite sure what i was looking for would be called. I need to display data from a mySQL table (dynamically?) on a website based on drop down boxes in a form. Does anyone know where i might find such a script?

for example: if i had a table with fields "name", "city", "date", and "site_name", and wanted to have drop down boxes for city and date, on submission of the form, a table would show the matching records.

I saw a few PHP scripts on this site, but they all had options to edit or add/delete records... all i want is to display them based on the form input. i know it is probably simple, but i am more of a code "borrower and modifier" than a code "author." Thank you for any help!!!

[FiRe]

drop down boxes:

Code:

<form action="submit.php" method="post">
City: <select name="city"><option value="london">london</option><option value="paris">paris</option><option value="hamburg">hamburg</option></select>
Date: <select name="date"><option value="01/01/06">01/01/06</option><option value="02/01/06">02/01/06</option><option value="03/01/06">03/01/06</option></select>
<input type="submit" value="Submit">
</form>

Now in submit.php:

PHP Code:

// Get the city

$city = $_POST['city'];



// Get the date

$date = $_POST['date'];



// Form the query

$query = "SELECT * FROM table WHERE city='$city' AND date='$date'";

$query = mysql_query($query);



// Start looping through each result

while ($r = mysql_fetch_array($query)) {



// Set the other information into variables

$name = $r['name'];

$site_name = $r['site_name'];



// Output the results (name and site name)

echo "Name: $name - Site Name: $site_name <br />";

} 

[Nico]

You forgot an "r" here:

PHP Code:

$site_name = $r['site_name']; 

[FiRe]

my bad :-p

[panqueconpasas]

thanks... i will try it out as soon as i finish my midterms...