database - Removing all decimals in PHP

Question

get this from my database:

252.587254564

Well i wanna remove the .587254564 and keep the 252, how can i do that?

What function should i use and can you show me an example?

Greetings

Answer 1

You can do it in PHP:

round($val, 0);

or in your MYSQL statement:

select round(foo_value, 0) value from foo