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.