RE: [PHP-DB] MySQL Query Question
| From: | John W. Holmes | Date: | Fri, 24 Jan 2003 02:25:01 +0000 |
| Subject: | RE: [PHP-DB] MySQL Query Question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25095@lists.php.net to get a copy of this message | ||
> I need some help from you MySQL gurus out there. This is pure SQL by
the
> way..no front-end.
>
>
> Lets say you have a table that has 2columns.....columnA,
> ColumnB and columnC
> I have something like this
Oh CRAP! You lost me... you said two columns but listed 3! ;)
> if (columnA>'7', (columnB/columnC) + 52, columnB/ColumnC) as
"Number"
I think someone already suggested these, but either include a WHERE c !=
0 in your WHERE clause (if you don't want those rows), or use a nested
IF() to return a specific value when C is zero:
IF(ColumnC=0,'Undef',IF(ColumnA>7,ColumnB/ColumnC+52,ColumnB/ColumnC))
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/