https://www.webmaster-forums.net/crss/node/1036349 en https://www.webmaster-forums.net/web-database-development/mysql-math-question#comment-1209205 <p>Brilliant! thanks for the help dude!</p> Sat, 21 Oct 2006 14:38:07 +0000 andy206uk comment 1209205 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/mysql-math-question#comment-1209204 <p>use [="Courier New"]<strong>SELECT (1 - `saleprice` / `oldprice` ) AS savings FROM `products`</strong>[/] to get a true numeric value (.50 for 50%, .75 for 75%)</p> <p>or us [="Courier New"]<strong>SELECT ((1 - `saleprice` / `oldprice` ) * 100 ) AS savings FROM `products`</strong>[/] to get just a whole number to display (75 for 75%)</p> <p>-Greg</p> Sat, 21 Oct 2006 13:45:43 +0000 Greg K comment 1209204 at https://www.webmaster-forums.net