Prev: Upgrading PHP Version 5.1.6
Next: RegExp
From: "Ron Piggott" on 9 Mar 2010 05:32 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
From: David Robley on 9 Mar 2010 07:06 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.
|
Pages: 1 Prev: Upgrading PHP Version 5.1.6 Next: RegExp |