Yes, it's possible.
You'll need to fetch all of the rows that you want as <option> elements, then loop through them and build the select list, adding a unique number or ID key to each one. When the user clicks the submit button, get the number or ID key from the selected option, run another query using the number or ID key to grab that row from the database and display it in the resulting page.
Quote:
Originally Posted by timbaker1991
I want populate a drop down list from a colum in a MySQL database, the drop down box is in an HTML file and i want to put the processing code in a php file, whats more on click of submit i want it to the return the whole of the row from which the drop down box selected, again in a HTML page.
Is this possible?
|