On Sat, Feb 28, 2009 at 12:41:12AM +0000, Ashley Sheridan wrote: > On Fri, 2009-02-27 at 16:58 -0500, Bastien Koert wrote: <snip> > That'll just return an empty result set, as in empty and with no fields > output! In MySQL you can do this: > > SELECT column_name FROM information_schema.columns WHERE table_name = > 'table_name' > > this might help with doing the same for M$Access? > This is the SQL standard way of doing this. Both MySQL and PostgreSQL support it. Don't know about MSSQL. Paul -- Paul M. Foster -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php