Get three decimal places

[gple]

$roster=mysql_query("select *, (hits/ab) as avg from softball_players, softball_rosters, softball_ostats where softball_ostats.roster_id=softball_rosters.id and softball_players.id=softball_rosters.player_id and softball_rosters.year='$year' order by avg desc");
$roster_num=mysql_numrows($roster);

 

How do I get avg to appear in three decimal places? Not two as this is outputting

[dark_mirage]

I don't totally understand what you mean, but i know you can format numbers with printf:

 

printf ("%01.3f", $MyNumber);

 

That should print to 3dp

 

Haven't actually used this before though, so someone please correct my if i am wrong

[gple]

When I output AVG. It rounds up to the second decimal place. I want to be able to output rounding up/down to the third decimal place.

[dark_mirage]

Well in that case, try using the code i just said, replacing $MyNumber with your own variable obviously lol

[gple]

I did and I am still getting it to two decimal places. I think something has to be done in the query where I coded (HITS/AB) as AVG. I think there is more coding involved here to have AVG go to three decimal places.

[dark_mirage]

Well i don't know then sorry  :-\ you'll have to wait for one of the guru's to check your post out, i doubt you'll have to wait long.

[gple]

Anyone else got an idea?

[atl_andy]

Could you limit the data the is entered into the database, so it is in the form you want when it is retrieved?

[GingerRobot]

If there's only two decimal places being shown without you doing anything, then it would suggest that the number can be shown exactly to two decimals - that is, can be written as a fraction with 100 as the denominator.

 

Perhaps you wanted 3 decimals to be shown regardless? So an extra 0 would be shown? If so, you can use the number_format() function:

 

echo number_format($var,3);

[gple]

When AB=7 and H=3. Then AB/H should output .428. Instead its outputting .43. and then when I use your code it outputs .430

[GingerRobot]

Im assuming you mean H/AB?

 

Either way, thats odd. Perhaps try doing:

 

select *, ROUND((hits/ab),3) as avg...

 

[gple]

sorry guys. I figured it out.

[gple]

Ah that was the code I was looking for. Now it works exactly the way I like it.