Home  |  Linux  | Mysql  | PHP  | XML
From:Ron Piggott Date:Tue Mar  9 10:32:52 2010
Subject:Rounding up results
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

Navigate in group php.db at sever news.php.net
Previous Next


Your recent visits
Re: Cannot connect to MySQL
Re: [PHP-DB] Upgrading PHP Version 5.1.6
Storing images
Re: [PHP-DB] Need Help with data sorting
MIME Alternatimve Emails



  
© No Copyright
You are free to use Anything, but please consult your advocate before doing so as this website
also list content from other sources which may be copyrighted.
Site Maintained by Zareef Ahmed
Powered By PHP Consultants