CODEWITHSUNDEEP
phpmysql
user2574794
user2574794

Reputation: 1006

Hiding the decimal if .0 and showing zero if an integer

I have two, hopefully basic number questions.

First, I am using the decimal data type on MySQL to show data like speed or height set to one decimal place like this decimal(4,1) My problem is that for numbers with no dp it is still showing .0 - What I get is '309.0' but what I want is '309'. What do I need to change to hide the '.0'?

Second I have an integer data type showing fixed numbers. Many of the numbers are 0 zero but these are getting treated as null and not displaying. How do I force the 0's to display? (I can't make table changes for this because other columns do have zero's that are null values. It is only this one column that needs zeros to display).

For both of these problems PHP is being used to display the results.

EDIT: code I'm using to display results. the top one needs to not show .0 the bottom one needs to show a zero.

Length:</b> %sft' . PHP_EOL, $row2['length'])

Inversions:</b> %s' . PHP_EOL, $row2['inversions'])

Upvotes: 0

Views: 1969

Answers (2)

asifrc
asifrc

Reputation: 5841

To check for the trailing zero, you could use the following to make sure that the float and integer values are the same:

$num = (floatval($num)==intval($num)) ? intval($num) : floatval($num);

and then for the null value, you could use coalesce(yourColumn, 0) as yourColumn to either get your column value if not null or return 0 as the value..

Upvotes: 0

Sterling Archer
Sterling Archer

Reputation: 22395

I believe a sneaky trick is if you add 0 to the end of your number, it removes the .0000 etc.

example:

$number = 150.00
$number = $number + 0; //should echo 150
$other_number = 150.500;
$other_number += 0; //should echo 150.5

As for the other, you can simply concatenate the zeros since no calculations seem to be needed

Upvotes: 4

Related Questions