Trouble With Select Box

[knashash]

I am populating a Select box with values from a database. I want to pass the value the user chooses to another form. When I retrieve the variable, it is truncated. Example..."Hello Dolly" becomes "Hello" anyone know how to get the whole word variable through? Below is my code....and please excuse the mess.

<form method="post" name="displayReviews" action="movies.php"><br>
Name:
<Select Name="movie_names">
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("chicago",$db);
$result = mysql_query("Select name From movies", $db);
mysql_close($db);
while($row = mysql_fetch_row($result))
{
foreach ($row as $name)
{
print "<option value=$name>$name";
}
}
?>
</select>
<input type="Hidden" name="hmovieName" value='<?php echo $movie_names;?>'>
<input type="Submit" value="See Reviews">
</form>
</td>
</tr>
<tr>
<td colspan="2">

Review:
<?php
$movieNames = $_POST["movie_names"];
print $movieNames;
?>

[laserlight]

Try:

print "<option value=\"$name\">$name";

or

print '<option value="' . $name . '">' . $name . '</option>;

you might want to use htmlspecialchars() on the output data just in case.

[knashash]

It seems to want another double qoute at the end otherwise my tags get messed up when I plugged in that first solution..are you sure that is right?

Thanks in advance

[mcgruff]

see urlencode() if you want to pass Hello Dolly via GET (ie in the query string)