Form / Drop Down Menu / MySql

[Jezreel]

Ok.. I am a beginner at Php/MySql, however most of the time I can feel my way around in the dark. However, trying to do this sort of hurts my head.

I need to have a drop down list inside of a form which retrieves the data for the drop down list from a MySql Database.

The data is in a table that will constantly be growing so obviously the items in the drop down list will grow as well. So the table is called "Songs" and the field is s_title. When the drop down list retreives the data I need it to place the songs in alphabetical order as well.

Any takers?

Thanks in advance,

[jheitz]

You need to run a query that returns all the songs in alphabetical order (very easy if ytou know SQL). Then in the .PHP file, when you are creating the SELECT element of the form for the combo box you need to go into PHP mode and LOOP through the resultset the query returned and create each element....

[Houdini]

Do you currently have any code at all such as the form and possibly a connection to a database and a databse selection along with a query?

[jheitz]

Here is an example I have used recently:

<select name="SelProjectName">
	<?php						
		$sqlquery="EXEC Get_Projects NULL;";
		$process=odbc_exec($sqlconnect, $sqlquery);

	while(odbc_fetch_row($process)){
		$ProjectName = odbc_result($process,"ProjectName");
		if ($ProjectDetails["ProjectName"] == $ProjectName) {
			echo "<option value='$ProjectName' selected>$ProjectName";
		} else {
			echo "<option value='$ProjectName'>$ProjectName";
		}
	}						
?>					
</select>

Hope it helps...