Ron Piggott wrote:

> 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

Does your location not let you access the mysql documentation?

David Robley

<CTRL>-<ALT>-<DEL> is the key to success
Today is Pungenday, the 68th day of Chaos in the YOLD 3176. 

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to