[PHP-DB] Re: Rounding up results

2010-03-09 Thread David Robley
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

[PHP-DB] Rounding up results

2010-03-09 Thread Ron Piggott
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