How to show radio button toggeld from database info on Update Page? 1

[MustangManny]

Hello.

I have an update page( form ) where the client can make changes to the info they have entered into a database.
One of the fields is a radio button group selection.

How do I populate the correct radio button from the database info, so they can see what the present choice was and can change it right there if needed to by clicking on another radio button.

Thanks in advance.

 

[HowardMarks]

Something along these lines will do the trick:


<input type="radio" name="field1" value="value1" <% If rs("field1") = "value1" Then %>selected<% End If %>>

<input type="radio" name="field1" value="value2" <% If rs("field1") = "value2" Then %>selected<% End If %>>

<input type="radio" name="field1" value="value3" <% If rs("field1") = "value3" Then %>selected<% End If %>>>



Nick (Webmaster)

info@npfx.com

http://www.npfx.com

http://www.artswales.org

 

[HowardMarks]

Sorry, those 'selected' should read 'checked'. I always get those confused!!

Nick (Webmaster)

info@npfx.com

http://www.npfx.com

http://www.artswales.org

 

[MustangManny]

Hello, yyou set me toward the right direction, thank you.
However, for some reason, theh rest of the fields under the radio buttons now do not populate from the database,but the ones before it do.

Why's that?

Thanks again.

 

[HowardMarks]

I couldnt be sure without seeing all of your code. Post it and I will have a luck.



Nick (Webmaster)

info@npfx.com

http://www.npfx.com

http://www.artswales.org

 

[MustangManny]

Found the cause!
For soem reason the code I have was extracting the fields from the database in the order of the columns, the one abovce being the last. I made it first and it worked fine!
Is there a parameter that restricts/unrestricts the order data is extracted from a databse?

Thank you so very much again!!!

 

[HowardMarks]

Yes, the ORDER BY statement.

for example

SELECT * FROM mydatabase ORDER BY datefield

otherwise the records just come out in the order they were put in.

is that what you were after?

Nick (Webmaster)

info@npfx.com

http://www.npfx.com

http://www.artswales.org

 

[MustangManny]

Yes, thank you.