dropdown & session problem

[del753]

Hi, im using the following to populate a dropdown menu from mysql which seems to work fine, i want to use these variables throughout though so i need to $_SESSION['Sname'] = $Sname; etc somewhere i presume? i've tried everything but with no luck

<?php

$sql="SELECT DISTINCT(Sname), Venue FROM shows1";
$result=mysql_query($sql);

$options="";
while ($row=mysql_fetch_array($result)) {

$Sname=$row["Sname"];
$options.="<OPTION VALUE=\"$Sname\">".$Sname;
}
?>

<FORM method = "POST" action = "book.php">
<SELECT NAME=Sname>
<OPTION VALUE=0>Choose a show
<?=$options?>
<INPUT TYPE=SUBMIT value = "Book Show">
</option>

thanks, help much appreciated

[devinemke]

you want to store the option list in the session? then you need to do $_SESSION['options'] = $options. you must first call [man]session_start[/man] before using sessions.

[del753]

im not sure if i want to store the option list in the session to be honest, i dont think so, i just want to be able to populate the dropdown & pick from it and move on with the selection being remembered, if i was to store the options how do i output the chosen option?
thanks

[devinemke]

Originally posted by del753
...i just want to be able to populate the dropdown & pick from it and move on with the selection being remembered

then in book.php you need to start a session and do:

if (isset($_POST['Sname'])) {$_SESSION['Sname'] = $_POST['Sname'];}

[del753]

thanks alot, that worked for the 'Sname', can the same be done for the rest of the details in the Shows1 table, while just picking by name? thank again!

[del753]

yeah, works fine for 'Sname' but the rest of the details dont come along with it?