array into <select> fields

[Anon]

Hi,

I wanted to put retrieved array list into nex page's <select> fields. My partial code like

$query = "SELECT name1, name2 from test left join try where test.name1=try.name1;

$result = safe_query ($query, $link);
if (!$result) { die (" No such $query "); }

if (isset($result)) {

while ($row = mysql_fetch_array($result))
{
echo("<p align=\"center\">");
echo("<font face=\"Arial\">");
echo ("<select name=\"name\" size=10 >");
echo ("<option>" .$row["ListName"]. "\n</option>");
echo ("</select>");
echo ("</font>");

}
}

after I hit submit button, no select field box in next page.

Do you know where it is problem?

[plutoplanet]

try this

if (!$result) { die (" No such $query "); }

if (isset($result)) {
echo("<p align=\"center\">");
echo("");
echo ("<select name=\"name\" size=10 >");
while ($row = mysql_fetch_array($result))
{
echo ("<option>" .$row["conTitle"]. "\n</option>");
}
echo ("</select>");
}

[Anon]

$query = "SELECT name1, name2 from test left join try where test.name1=try.name1;

you need to add the " to the end of your $query statement.

[Anon]

Hi,

Yes, I tried like your suggestions, I still can't get data, but select function display, just now data in <select>.