mysql row array reference query

[jesus_hairdo]

I have an sql query 'Select *, DATE_FORMAT(date, '%d %m %Y') from table'

what i want to do is to reference the row using a associative array, ie $row['firstname'] displays the firstname. The only problem is i don't know how to reference the DATE_FORMAT . will it be $row['DATE_FORMAT'] ?
any ideas ?

cheers

Jamie

[[deleted]]

use

SELECT DATE_FORMAT(bladebla) AS mydate

then reference 'mydate'