Re: mysql_fetch_object

Bob Lockie wrote:

On 06/28/2004 12:07 PM Larry E.Ullman spoke:

I'm using $row = mysql_fetch_object and I can reference column names by $row->name but how do I reference a pseudo column (that I make, like substring( name from 1 ))?

Use an alias in your query: SELECT column, DATE_FORMAT('%m', date_column) AS d FROM table ... $row->d Larry

How does it handle fully qualified conflicting columns, like 'select a.name, b.name from a, b'?

It won't handle that properly; in your example $row->name would be b.name (it'd overwrite a.name). You have to alias same-named columns. Hans