On Sat, Feb 28, 2009 at 5:08 AM, Ashley Sheridan <ash@xxxxxxxxxxxxxxxxxxxx> wrote: > On Sat, 2009-02-28 at 00:40 -0500, Andrew Ballard wrote: >> On Fri, Feb 27, 2009 at 7:41 PM, Ashley Sheridan >> <ash@xxxxxxxxxxxxxxxxxxxx> wrote: >> > On Fri, 2009-02-27 at 16:58 -0500, Bastien Koert wrote: >> >> On Thu, Feb 26, 2009 at 4:01 PM, revDAVE <Cool@xxxxxxxxxxxxxxxx> wrote: >> >> >> >> > Newbie question: >> >> > >> >> > I would like to get a list of column field names from a MS Access table and >> >> > hopefully get them returned in the ORIGINAL order (as they appear in >> >> > access) >> >> > >> >> > Is there a sql query I could do to get this result? >> >> > >> >> > >> >> > >> >> > >> >> > -- >> >> > Thanks - RevDave >> >> > Cool @ hosting4days . com >> >> > [db-lists 09] >> >> > >> >> > >> >> > >> >> > >> >> > -- >> >> > PHP General Mailing List (http://www.php.net/) >> >> > To unsubscribe, visit: http://www.php.net/unsub.php >> >> > >> >> > >> >> A dirty way is to query the table where 1=2 to return no results >> >> >> >> select * from table where 1=2 >> >> >> > 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? >> > >> > >> > Ash >> > www.ashleysheridan.co.uk >> > >> >> I haven't ever seen information_schema in M$ Access. >> >> Andrew >> > I guess then you could do something like this: > > $row_names = Array(); > $query = "SELECT TOP 1 * FROM table_name"; > $result = mssql_query($query); > while($row = mssql_fetch_array($result)) > { > foreach($row as $key => $value) > { > $row_names[] = $key; > } > } > > I know it's a little messy there with the double loop, and I'm sure we > can get rid of the while, but I've just woken up, so I'm not too compos > mentis just yet! > > > Ash > www.ashleysheridan.co.uk > > I don't even think TOP exists in Access, but I've never tried it there either. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
