Rounding up results

[email protected] ("Ron Piggott")
Newsgroups php.db
Message-ID <b53071a746edc5861a453ec9ca13f2eb.squirrel@www.theverseoftheday.info>
Is there a way to round up in mySQL?  This result may give 3.2 --- so I
want the result to be 4?

SELECT  ( count(`reference`) / $items_per_page ) AS total_pages FROM
`store_product_profile` WHERE `store_category_reference` =$reference AND
`live` =1
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.