Re: Rounding up results
| From: | David Robley | Date: | Tue, 09 Mar 2010 12:06:48 +0000 |
| Subject: | Re: Rounding up results | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46940@lists.php.net to get a copy of this message | ||
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?
http://dev.mysql.com/doc/refman/5.1/en/mathematical-functions.html
Cheers
--
David Robley
<CTRL>-<ALT>-<DEL> is the key to success
Today is Pungenday, the 68th day of Chaos in the YOLD 3176.