vikingbear Posted April 4, 2010 Share Posted April 4, 2010 Hi, I have a database field containing a number eg. 3.75, I want to repeat the field in the next column and add 10% (gst) how would I code that? <?php echo $row_Recordset1['Price_75mm']; ?> | <?php echo $row_Recordset1['Price_75mm']; ?> Any input greatly appreciated! Regards, ken Quote Link to comment Share on other sites More sharing options...
Daniel0 Posted April 4, 2010 Share Posted April 4, 2010 Uh, multiply by 1.1? Quote Link to comment Share on other sites More sharing options...
vikingbear Posted April 4, 2010 Author Share Posted April 4, 2010 Clever answer, but HOW I am not a php coder, cheating by using Dreamweaver.. Regards, Ken Quote Link to comment Share on other sites More sharing options...
ignace Posted April 4, 2010 Share Posted April 4, 2010 $row_Recordset1['Price_75mm'] * 1.1 Quote Link to comment Share on other sites More sharing options...
vikingbear Posted April 4, 2010 Author Share Posted April 4, 2010 Works brilliantly, but how do you round up to 2 decimals Regards, Ken Quote Link to comment Share on other sites More sharing options...
Daniel0 Posted April 4, 2010 Share Posted April 4, 2010 You round using the round function. Quote Link to comment Share on other sites More sharing options...
ZachMEdwards Posted May 29, 2010 Share Posted May 29, 2010 <?php echo round($row_Recordset1['Price_75mm']*1.1,2); ?> | <?php echo round($row_Recordset1['Price_75mm']*1.1,2); ?> Quote Link to comment Share on other sites More sharing options...
ignace Posted May 30, 2010 Share Posted May 30, 2010 <?php echo round($row_Recordset1['Price_75mm']*1.1,2); ?> | <?php echo round($row_Recordset1['Price_75mm']*1.1,2); ?> He said second column <?php echo $row_Recordset1['Price_75mm']; ?> | <?php echo round($row_Recordset1['Price_75mm']*1.1,2); ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.