nfvindaloo

Hi I need to retrieve columns from the same table twice, using aliased names in the query. When php retrieves a record i would expect ambiguous column names to be prefixed with the table name; ie: table.column, but mysql_fetch_assoc() seems to overwrite the ambigous columns so i only get the data from the last alias of the table. There must be a way around this, is there a config option / runtime setting? Thanks, Nic