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
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
