aaronlzw_21 Posted May 8, 2006 Share Posted May 8, 2006 hi i have a small prob here. mysql table's column is in decimal with two decimal places. to store prices. i used a for loop to display the results in a form of a html table. but the results shown are always without the decimal places. did i do something wrong? here are my codes,$queryResult = mysql_query($query)$results = mysql_num_rows($queryResult)for ($i=0; $i<$results; i++){$row = mysql_fetch_array($queryResult);echo "<td>". $row['monthlyCost']. "</td>";}its not the complete code but its something like that. thanks! Link to comment https://forums.phpfreaks.com/topic/9291-data-retrieve-from-mysql-is-not-in-double/ Share on other sites More sharing options...
ober Posted May 8, 2006 Share Posted May 8, 2006 You have to use number_format() to display any kind of precision, unless MySQL provides a number formatting function. Link to comment https://forums.phpfreaks.com/topic/9291-data-retrieve-from-mysql-is-not-in-double/#findComment-34291 Share on other sites More sharing options...
aaronlzw_21 Posted May 9, 2006 Author Share Posted May 9, 2006 [!--quoteo(post=372274:date=May 8 2006, 10:35 PM:name=ober)--][div class=\'quotetop\']QUOTE(ober @ May 8 2006, 10:35 PM) [snapback]372274[/snapback][/div][div class=\'quotemain\'][!--quotec--]You have to use number_format() to display any kind of precision, unless MySQL provides a number formatting function.[/quote]erm i dun get wat u mean.. Link to comment https://forums.phpfreaks.com/topic/9291-data-retrieve-from-mysql-is-not-in-double/#findComment-34472 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.