Hi there!
There's no stopping me, I try to push it to the limits! :-)
Anyway, yet another questions, or 'problem' I run into.
I have a table in a database with names of musictracks, and a table which links the tracknames to the items, so that you can also search "On which CD(s) can I find this track?".
I want to present the table with tracknames in an optionlist, though I don't seem to be able to get the data from that list exported to the form.
So the script below is being included in a form, as an optionlist, as you can see from the data.
When I submit the form, it will always have the last record from the databasetable submitted.
Thanks very much for all your help! You're great!
Marijn
<?
include("../../../dbconnect.php");
$sql = "SELECT * FROM shoptracks ORDER BY track";
$result = @mysql_query($sql);
?>
<SELECT NAME="trackID">
<?
while ($row = mysql_fetch_array($result)) {
$track = $row["track"];
$trackID = $row["ID"];
?>
<OPTION VALUE="<? echo($trackID); ?>"><? echo($track); ?>
<?
}
?>
</SELECT>
