[SOLVED] Limiting float element tables

[peddel]

I got a table filled with float values.

When i join it with other tables, my floats get out in this form

24.390503839

 

Is it possible to limit the floats with a command so that i get for example 24.39?

 

Thx in advance

[Philip]

Take a look into ROUND(), it should be what you're looking for

[peddel]

Take a look into ROUND(), it should be what you're looking for

 

Thx man, seems indeed what im looking for ^^

[peddel]

Dear KingFilip,

 

i tought i found the solution, but it seems i did not.

 

My MySQL query

$sql = "SELECT view1.tag, view1.waarde FROM registratie "
."LEFT JOIN view1 ON registratie.registratieID = view1.registratieID "
."LEFT JOIN oorsprong_gegevens ON registratie.oorsprong = oorsprong_gegevens.oorsprong "
."WHERE registratie.productieregister = '1' AND view1.tag = 'uurtellerAmmoniak' ";

 

The thing now is that when the tag is a float and it finds a float value, i ask through php to add the value to a webpage on a certain position.

 

The representation is 34.919955433

 

Now where do i place best the ROUND() function in my query, to be sure i get 34,92.

OR do i need to do the rounding in PHP ?

[peddel]

I solved it

It was easily done by using the PHP round() function.

Thx for ur help again ^^

[fenway]

No idea what you mean... but you can use ROUND() in mysql too.