Drop Down Menu

[keyvanrahmadi]

Hello every one,

I have just recently started learning Mysql/PHP and i am trying to design a page with drop down menus which will allow the user to select what they want to see and submit the query. So far this is how far i have gone, which i am sure is not far.

[PHP]<?PHP

// Connecting to the database server
$link = mysql_connect("connection", "user", "pass");
// Selecting database
mysql_select_db("db");

// Performing MYSQL query
$result = mysql_query('SELECT name FROM location_o2')
or die('Query failed: ' . mysql_error());


// Printing results in HTML
echo "<form action='#'>\r\n<select name=location>\r\n";
while ($line = mysql_fetch_array($result, MYSQL_NUM)) {
$house = $line[0];
echo " <option value=$house>$house\r\n";
}
echo "</select>\r\n <input type=submit value=SELECT>\r\n</form>\r\n";

?>[/PHP]

The above will create a drop down menu with 2 entry (London, Liverpool). The concept is that the user selects a city and by submiting their choice they can in this case see all the available cars in that city.

any ideas and suggections will be greatly appriciated.

keyvan

[Motoma]

Welcome to The Scripts, keyvanrahmadi.

What type of suggestions are you looking for?

[keyvanrahmadi]

Welcome to The Scripts, keyvanrahmadi.

What type of suggestions are you looking for?

I am sorry i should have been more clear, whats confusing me is how i can use the user's choice from menu and out put the result on the same page.

http://ati.amd.com/support/driver.html

Above link will show you what i have in mind, a bit ambitious for starter like me but hey i like jumping in the deep end and try to figure it out.

keyvan

[cassbiz]

When I went over to amd's site, are you referring to the drop down menu in regards to selecting your location.

This is handled via Javascript.

Or are you referring to a different part of the page?

[Motoma]

I have moved this thread to the Javascript forum. The folks there should be much more helpful.

[r035198x]

Hello every one,



I have just recently started learning Mysql/PHP and i am trying to design a page with drop down menus which will allow the user to select what they want to see and submit the query. So far this is how far i have gone, which i am sure is not far.



<?PHP



// Connecting to the database server

$link = mysql_connect(\"connection\", \"user\", \"pass\");

// Selecting database

mysql_select_db(\"db\");



// Performing MYSQL query

$result = mysql_query(\'SELECT name FROM location_o2\')

or die(\'Query failed: \' . mysql_error());





// Printing results in HTML

echo \"<form action=\'#\'>\\r\\n<select name=location>\\r\\n\";

while ($line = mysql_fetch_array($result, MYSQL_NUM)) {

$house = $line[0];

echo \" <option value=$house>$house\\r\\n\";

}

echo \"</select>\\r\\n <input type=submit value=SELECT>\\r\\n</form>\\r\\n\";



?>



The above will create a drop down menu with 2 entry (London, Liverpool). The concept is that the user selects a city and by submiting their choice they can in this case see all the available cars in that city.



any ideas and suggections will be greatly appriciated.



keyvan

Have a read at this thread.

[r035198x]

Have a read at this thread.

Or maybe this one.

[acoder]

r0, those links point to http://this/ (!!)

[r035198x]

r0, those links point to http://this/ (!!)

Something went wrong with my links there. Try



http://www.thescripts.com/forum/thread583887.html

[keyvanrahmadi]

I would like to thank every one for thier input and various hints and links the provided.. it has helped greatly.

keyvan

[acoder]

No problem, you're welcome. If you have any more problems, feel free to post again.

[r035198x]

I would like to thank every one for thier input and various hints and links the provided.. it has helped greatly.



keyvan

I am not sure if all the links posted helped you.

[acoder]

I am not sure if all the links posted helped you.

Well, at least the last one did.