Re: need your opinion

Yes Mike, but if it's a larger database you might wanna use the functions in MySQL instead. Then you will save time and memory by not selecting everything everytime and then process it in php. Take a look at 7.4.9 in MySQL doc (http://www.mysql.com/doc/M/a/Mathematical_functions.html). /Johan Michael Rudel wrote: > > Hi Afan. > > U can use the ceil() -function. > Look in the manual @section: XXXIII. Mathematical Functions > > Greetinx, > Mike > > Michael Rudel > - Web-Development, Systemadministration - > _______________________________________________________________ > > Suchtreffer AG > Bleicherstraße 20 > D-78467 Konstanz > Germany > fon: +49-(0)7531-89207-17 > fax: +49-(0)7531-89207-13 > e-mail: mailto:mru@suchtreffer.de > internet: http://www.suchtreffer.de > _______________________________________________________________ > > > -----Original Message----- > > From: afan [mailto:afan@sprout.net] > > Sent: Friday, April 27, 2001 10:38 PM > > To: php-windows@lists.php.net > > Subject: [PHP-WIN] need your opinion > > > > > > Hi all, > > I made a simple code but I think that there is a better way > > to do same thing. > > > > I have list with couple hundreds "entries" and I want to have > > it 50 per page. > > I did it this way and it works. > > > > > > $result = mysql_query("SELECT id FROM source ORDER BY id ASC", $db); > > while($myrow = mysql_fetch_array($result)) > > { > > $IDArray[] = $myrow[id]; > > } > > $NoOfEntries = count($IDArray); // Number of entries > > $NoOfPages = $NoOfEntries / 50; // Number of pages > > with 50 entries per page > > > > // E.g. 3.854 pages means 4 pages. The way I'm doing > > is check is $NoOfPages > integer($NoOfPages) > > > > $NoOfPagesInt = $NoOfPages; > > settype($NoOfPagesInt, "integer"); > > if($NoOfPages > $NoOfPagesInt): > > $NoOfPages++; > > endif; > > > > > > Any suggestions? > > > > Thanks! > > > > Afan > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net