Session POST

euge

Hi, ive got this query, it works fine for 'Name' but for 'Duration', its outputting the last one in my table rather than the selected one?
$sql="SELECT Name, Duration FROM films";
$result=mysql_query($sql);
$options="";
while ($row=mysql_fetch_array($result)) {

$Name=$row["Name"];
$Duration=$row["Duration"];
$options.="<OPTION VALUE=\"$Sname\">".$Sname;

$SESSION['Duration'] = $Duration;
$Duration = $POST['Duration'];

on the following page....
if (isset($POST['Name'])) {$SESSION['Name'] = $POST['Name'];}
if (isset($POST['Duration'])) {$SESSION['Duration'] = $POST['Duration'];}

thanks...

LordShryku

You're overwriting the session variable with each iteration through your loop. You'd probably want to pass an array of values with the appropriate name as the key so you can match them on the second page. Or, just don't even pull duration. Pull the name, then pull the duration on the second page with the name that is passed.

euge

not trying to build an array, trying to select a film and then show the name and duration of it, i've got 10 films in my db, the name part works fine but the duration part picks up the last films duration every time instead of the selected ones....

euge

"then pull the duration on the second page with the name that is passed"

exactly...how!?!

LordShryku

Like this!?!

$sql = "SELECT Duration 
          FROM films 
         WHERE Name =  '".$_POST['Name']."'";

euge

thanks alot for your help, but can it be done the way i'm outputting the name i.e.

if (isset($POST['Name'])) {$SESSION['Name'] = $_POST['Name'];}

The movie you picked is<strong><? echo $_SESSION['Name']; ?></strong>!<br />