Re: mysql_fetch_object
| From: | Larry E . Ullman | Date: | Mon, 28 Jun 2004 16:07:35 +0000 |
| Subject: | Re: mysql_fetch_object | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35019@lists.php.net to get a copy of this message | ||
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