list menu tutorial
Posted 06 April 2004 - 08:00 PM
I can also creat a dropdown List/menu
But I cannot find a tutorial that enables me to get the dropdown list to retrieve the information from the database using PHP
many thanks in anticipation for any help and advice.
Posted 06 April 2004 - 09:32 PM
Posted 06 April 2004 - 09:33 PM
Posted 07 April 2004 - 06:10 PM
I have one set up and working where enter a pull down list in a form and create a query to dipsplay the info in the pull down dynamically, and then name the list field. I then and a submit button and link the form to the page that display the info.
I use this so out two people controling our equipment inventory can echange information on each model back and forth. Each model is in the pull down, once selected they can edit the information it brings up.
Query to pull information diplayed in menu/list
SELECT model FROM yankee_equipment_inv ORDER BY model ASC
I am using MySQL and I write a query to select information by what is displayed in the list when submitted.
Query to pull info from menu/list
SELECT id, model, stock, sold, on_order, comments FROM yankee_equipment_inv WHERE model = 'colname' ORDER BY model ASC
colname = name of list/menu this is set then you create the recordset in DW.
This worked for me fairly easily, though I might not be explaining it right.
I can try to give more information if you need it.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users