[Tim Mousel]

Hi,

Here's the scenario:

From an admin panel, the admin creates a table that has the following fields:
item, name, rating, rating1, rating2, rating3, etc...

Each rating field will have a name associated with it such as:
Quality (rating1), Durability (rating2), Satisfaction (rating3), etc...

It could be an unlimited amount of rating[$i] fields.

Now, on the user side, how would I dynamically create my form based on the unknown number of fields in the database?

Hope that makes sense!

Thanks,

Tim

i know asp, but in there we do

this should give you the idea(s) and then be able to convert it.

Code:

 	<table border="1" cellspacing="0">
 	  <tr>
 	  <% For i = 0 to rsCustomQuery.Fields.Count - 1 %>
 		    <TD><B><% = rsCustomQuery(i).Name %></B></TD>
 			<% Next %>
 	  </tr>
 	  <%
 		Do While Not rsCustomQuery.EOF
 		  %>
 	  <tr>
 			<% For i = 0 to rsCustomQuery.Fields.Count - 1 %>
 		    <TD VALIGN=TOP><% = rsCustomQuery(i) %></TD>
 			<% Next %>
 	  </tr>
 		  <%
 			rsCustomQuery.MoveNext
 			Loop
 	  %>
   </table>

[Acecool]

'SHOW FULL FIELDS FROM table'

That query should return all the fields