Re: Average
| From: | Nick Gorham | Date: | Fri, 23 Aug 2002 09:19:22 +0000 |
| Subject: | Re: Average | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21322@lists.php.net to get a copy of this message | ||
Jj Harrison wrote:
I want to average some stuff in a db with a left join. how can I return 3 if there is nothing to average for a specific entry. ( I have a comments and an article table. Comments are left joined to the article table)Try IFNULL( column, 3 ) or some such usage
-- JJ Harrison webmaster@tececo.com www.tececo.com -- Please reply on the list/newsgroup unless the reply it OT.