[SOLVED] dynamic drop down list

[Mossman]

Hi,

 

I have been reading previous threads on dynamic lists.  I just want to populate a list with a field from a table.

 

The code I am using is:

 

echo "<select name='selectcompany'>";
echo "<option value=$row[ar_name]>$row[ar_name]</a></option>";
echo "</select>";

 

It is taking each record and putting the results in their own seperate lists rather than all in the same drop down list.  I know it's probably something simple I'm not doing but I've tried other peoples solutions and it's not working for me.

 

I'd appreciate any suggestions!

[rajivgonsalves]

post your while loop

[corillo181]

i don't understand your question.

 

you have multiple company that you want to add to the select company drop down box?

[Mossman]

it's looking like this:

 

while ($row = mysql_fetch_assoc($result)) 
{
echo "<form>";
echo "<select>";
echo "<option>" . $row['ar_name'] . "</option>";
echo "</select>";
echo "</form>";
}mysql_close($con);
}

[Mossman]

i don't understand your question.

 

you have multiple company that you want to add to the select company drop down box?

 

Yes that's right.  So the user can choose a company from a drop down list.

[rajivgonsalves]

should be

 

echo "<form>";
echo "<select>";
while ($row = mysql_fetch_assoc($result)) 
{
echo "<option>" . $row['ar_name'] . "</option>";
}
echo "</select>";
echo "</form>";

[corillo181]

echo "<form>";
echo "<select>";
while ($row = mysql_fetch_assoc($result)) 
{
echo "<option>" . $row['ar_name'] . "</option>";
}

echo "</select>";
echo "</form>";mysql_close($con);
}

 

i know you can tell the problem now.

 

[Mossman]

Ah that seems to have done the trick!  Thank's for the help!  I'd chopped and changed it so much I was totally lost.  Thanks guys.

[corillo181]

no problem remember to click the solved button.