> I need some help from you MySQL gurus out there. This is pure SQL by
> 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
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:
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php