Hi Guys,
Ive got a MASSIVE sql query that returns to columns, But doesnt actually have a colum name.

Normlaly i could use
while($row = mssql_fetch_array($result))
{
echo " Layer3Id " . $row["Layer3Id"];
echo " CustID " . $row["CustomerId"];
}

However
in this case i cant use the names..

How can i still achieve the same output without column identifiers?

IE:
currently it whines that theres undefined indexes ( because the column has no name )

It WILL have column names, even a "SELECT * FROM" returns with column names.

IF you know the order of the columns in the table you could use $row[numeric_index]; (zero based array index), but this will "break" should the table (s) be restructured at some time in the future.

Hi Thanks,

Ive found if i use, Select blaa from X AS Name ( inner join, convert etc etc etc ) as Otherthing

It works.

I forgot you could force column names

Ty for your help chris.