pwaterma Posted May 11, 2006 Share Posted May 11, 2006 I am having a heck of a time finding out how to format numbers displayed from a query. Can someone show me how to make format Salary with commas?Much appreciated<td><?php echo $row_Recordset1['Salary']; ?></td><td><?php echo $row_Recordset1['Cap_hit']; ?></td><td><?php echo $row_Recordset1['Cap_hit_preJune']; ?></td><td><?php echo $row_Recordset1['Cap_hit_postJune']; ?></td> Quote Link to comment Share on other sites More sharing options...
toplay Posted May 11, 2006 Share Posted May 11, 2006 Look at using one of these two functions:[a href=\"http://us2.php.net/number_format\" target=\"_blank\"]http://us2.php.net/number_format[/a][a href=\"http://us2.php.net/manual/en/function.money-format.php\" target=\"_blank\"]http://us2.php.net/manual/en/function.money-format.php[/a] Quote Link to comment Share on other sites More sharing options...
pwaterma Posted May 11, 2006 Author Share Posted May 11, 2006 [!--quoteo(post=373164:date=May 10 2006, 08:12 PM:name=toplay)--][div class=\'quotetop\']QUOTE(toplay @ May 10 2006, 08:12 PM) [snapback]373164[/snapback][/div][div class=\'quotemain\'][!--quotec--]Look at using one of these two functions:[a href=\"http://us2.php.net/number_format\" target=\"_blank\"]http://us2.php.net/number_format[/a][a href=\"http://us2.php.net/manual/en/function.money-format.php\" target=\"_blank\"]http://us2.php.net/manual/en/function.money-format.php[/a][/quote]i have looked at these and others. they all appear to be formatting a value that is manually defined.$number = 1234.56;i don't understand how to apply it to $row_Recordset1['Salary']; Quote Link to comment Share on other sites More sharing options...
toplay Posted May 11, 2006 Share Posted May 11, 2006 <td><?php echo number_format($row_Recordset1['Salary']); ?></td> Quote Link to comment Share on other sites More sharing options...
pwaterma Posted May 11, 2006 Author Share Posted May 11, 2006 [!--quoteo(post=373167:date=May 10 2006, 08:48 PM:name=toplay)--][div class=\'quotetop\']QUOTE(toplay @ May 10 2006, 08:48 PM) [snapback]373167[/snapback][/div][div class=\'quotemain\'][!--quotec--]<td><?php echo number_format($row_Recordset1['Salary']); ?></td>[/quote]perfect thank you so much! 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.