Get Column Name

I'm running a PHP call to MS SQL to automatically look in sysbojects
and syscolumns to get each table name in realtime so I can make a list
and execute it. That part's fine. I'm having problems though getting
the name of the first column, so we can use that as the default sort.
Can anybody help? Thanks.

Re: Get Column Name

What do you mean by first column? You can use columnID = 1 if you want the
first column in a table, but shouldnt you use something like first column in
grid or something like that?

MC


"Eddie" wrote in message
news:1192120862.530325.228710@50g2000hsm.googlegroups.com...
> I'm running a PHP call to MS SQL to automatically look in sysbojects
> and syscolumns to get each table name in realtime so I can make a list
> and execute it. That part's fine. I'm having problems though getting
> the name of the first column, so we can use that as the default sort.
> Can anybody help? Thanks.
>