mssql 2000 problem

Guyv

im using php with mssql 2000.
i use mssql_fetch_array to get the data from the database.
like: $line = mssql_fetch_array($rs);
but when i try to use $line["FIELDNAME"] to get the field value
i get nothing. if i'll use the offset number: $line[1]
i'll get the correct data.
FIELDNAME is smaller then 30 chars.
appriciate any help or insights
thanks
Guy

nnichols

I have never come across this problem with mssql.

It might be something simple like you are using $line['FIELDNAME'] when the db is returning "TBLNAME.FIELDNAME". You can check this quite simply by using any of the GUIs for running queries against the db and see what it presents for the column headers, or just try adding the tbl_name/tbl_alias and see if it works.

Hope this helps 😉

jerdo

The problem could be you put this:

$line["FIELDNAME"]

instead of this:

$line['FIELDNAME']

or this:

$line[FIELDNAME]

Sxooter

Originally posted by Guyv
im using php with mssql 2000.
i use mssql_fetch_array to get the data from the database.
like: $line = mssql_fetch_array($rs);
but when i try to use $line["FIELDNAME"] to get the field value
i get nothing. if i'll use the offset number: $line[1]
i'll get the correct data.
FIELDNAME is smaller then 30 chars.
appriciate any help or insights
thanks
Guy

Try this:

$line = mssql_fetch_array($rs);
print implode(":",array_keys($line));