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