how to retreive data from rebDB?

[newbie]

Hi, how to retreive the data from the database and display the result on to the textbox or label in cgi format. Thank you  

[Ashley]

I'm no CGI expert, but in general terms you might look at something like:

Code:

foreach [col1 col2] db [select [col1 col2] from table][
   print rejoin ["<tag>" col1 "</tag>"]
   print rejoin ["<tag>" col2 "</tag>"]
]

You might also want to check out the following REBOL functions for some inspiration:

[li]build-markup
[li]build-tag
[li]parse-xml