Putting database output in <option> field - how?

I'm trying to return to a user the result of his web form address
input, with one element being the country of his choice. If he
approves, the form forwards it as part of the approved data; if he
doesn't approve, he has the chance to select another country. The
following doesn't work (hope it's clear) -



Afghanistan
Aland Islands
Albania
etc etc

How do I do it, plase? TIA.

Re: Putting database output in <option> field - how?

am 11.06.2007 22:08:38 von zeldorblat

On Jun 11, 3:15 pm, jobo...@hotmail.com wrote:
> I'm trying to return to a user the result of his web form address
> input, with one element being the country of his choice. If he
> approves, the form forwards it as part of the approved data; if he
> doesn't approve, he has the chance to select another country. The
> following doesn't work (hope it's clear) -
>
>

>
> Afghanistan
> Aland Islands
> Albania
> etc etc
>
> How do I do it, plase? TIA.

What "doesn't work?" How do you know it "doesn't work?" Is there an
error message?

Re: Putting database output in <option> field - how?

"ZeldorBlat" wrote in message
news:1181592518.874215.125700@q75g2000hsh.googlegroups.com.. .
> On Jun 11, 3:15 pm, jobo...@hotmail.com wrote:
> > I'm trying to return to a user the result of his web form address
> > input, with one element being the country of his choice. If he
> > approves, the form forwards it as part of the approved data; if he
> > doesn't approve, he has the chance to select another country. The
> > following doesn't work (hope it's clear) -
> >
> >
> >
> > Afghanistan
> > Aland Islands
> > Albania
> > etc etc
> >
> > How do I do it, plase? TIA.
>
> What "doesn't work?" How do you know it "doesn't work?" Is there an
> error message?
>

Try this:


$Row[country]
Afghanistan
Aland Islands
Albania
etc etc

Re: Putting database output in <option> field - how?

> Try this:
>
>
> $Row[country]
> Afghanistan
> Aland Islands
> Albania
> etc etc
>

I think he actually means how does he populate the list of countries from a
list in the db.

To do this you need to loop through the results. Something like:-

echo ""
while ($row = mysql_fetch_array($db))
{
echo "$row[0]"
}
echo ""