You said you access your Access through ODBC, if I understood correctly. ODBC has reasonably standard cursor support, and certinly the simplest case (non-updateable non-scrollable) you have here. The question is whether PHP ODBC interface has appropriate mapping mechanisms (I know nothing about PHP).

BTW, some advanced tools like Panther (see open source version) do this automagically: you draw your form, name fields the same as database columns (there are other mapping mechanisms, of course) and emit SELECT. It will declare the cursor 'behind the scenes' and populate as much rows as there are on the form (one can do this explicitly, as well).

Dragi "Bonzi" Raos
Zagreb, Croatia
Q#5196, MkII#80000376, 18GB green

Edited by bonzi on 24/10/01 12:50 AM.

_________________________
Dragi "Bonzi" Raos Q#5196 MkII #080000376, 18GB green MkIIa #040103247, 60GB blue