how tocorrectly select multiple options?

Hi,

Why I always only retrieve one option's data even though I chose more than one options from drop-down box? Always only got last option's data.

My cpartial code is :

echo ("<select name=\"Name[]\" multiple size=10>");

If (isset($result)) {

while ($row = mysql_fetch_array($result))
{
print_r ("<option>" .$row["Name"]. "\n</option>"); }
}
echo ("</select></td></tr>");

Hi,

I think I need to clarify question via pasting my query:

$query= "SELECT Catagory.LName, Ename.Name
FROM Catagory INNER JOIN Ename ON Catagory.ID =

Ename.ListID WHERE Catagory.LName='$LName'";

$result = safe_query ($query, $link);

echo ("<select name=\"Name[]\" multiple size=10>");

If (isset($result)) {

while ($row = mysql_fetch_array($result))
{
print_r ("<option>" .$row["Name"]. "\n</option>"); }
}
echo ("</select></td></tr>");

Do you think that $query need to write array too?

Try changing:
print_r ("<option>" .$row["Name"]. "\n</option>");
to:
print_r ("<option value=" . $row[Name] . ">" .$row["Name"] );

That should fix your problem, if I understand the problem in the first place 🙂

-Rich

Hi,

I already got answers.

I have to add Loop to execute my array list.