> 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
today. http://www.phparch.com/

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to