Rounding up results

["Ron Piggott" <ron.piggott@xxxxxxxxxxxxxxxxxx>]

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


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php