Re: [PHP-DB] Optimal mySQL query for next prev page system

2003-11-19 Thread Kim Steinhaug
Thanks for the replies. Its time for me to start do some patching for my SQL statement, :) -- Kim Steinhaug --- There are 10 types of people when it comes to binary numbers: those who understand them, and those who don't.

Re: [PHP-DB] Optimal mySQL query for next prev page system

2003-11-18 Thread Adam i Agnieszka Gasiorowski FNORD
Kim Steinhaug wrote: Then I query the mySQL database again to get the final result set, which I return together with the buildt prev/next htmlkode Instead of querying twice, use the SQL_CALC_FOUND_ROWS parameter of SELECT statement and then do a quick SELECT HIGH_PRIORITY

Re: [PHP-DB] Optimal mySQL query for next prev page system

2003-11-18 Thread John W. Holmes
Adam i Agnieszka Gasiorowski FNORD wrote: Kim Steinhaug wrote: Then I query the mySQL database again to get the final result set, which I return together with the buildt prev/next htmlkode Instead of querying twice, use the SQL_CALC_FOUND_ROWS parameter of SELECT statement and then do