Inserting query Responses into a form table

parmy · #1 (**permalink**) 03-09-05, 07:00

Hi guyz i wanted to ask if anyone knows how to insert data from a query into a table in a form. I am using ASP and mysql for the db.

I havn't a clue how to start tackling this one. Do i need to create a table first hand or can i run a script which creates the table as it displays the query... so that the script creates the numbers of rows in the form tabel to match the number of rows returned by the query? I want to return the top 3 rows from my table using the nearest date and display these.

I'd be greatful for any pointers or links where this process is explained. Thanks alot.

plsh · #2 (**permalink**) 03-09-05, 09:13

Am I correct in asuming you want to display the results from a query in a table in asp?? The resultset is what you want displayed?

parmy · #3 (**permalink**) 03-09-05, 10:24

Yes thats right, i want to display the query results. Sorry if i didnt make any sense.

Bullschmidt · #4 (**permalink**) 03-09-05, 22:03

Perhaps check this out:

Database GetRows
http://www.asp101.com/samples/db_getrows.asp

And perhaps check out the other database samples at www.asp101.com/samples

plsh · #5 (**permalink**) 03-10-05, 02:03

This is perhaps not the best solution but works for me:

Code:

<table>
<%
While not recordset.eof
  response.write "<tr><td>" & recordset("fieldname") & "<\td><\tr>"
  recordset.movenext
Wend
%>
</table>

Very basic example, but should give you an idea.

Internet Services

Web Development

Digital Marketing

Consumer Tech