[PHP-DB] MySQL: Top $num results

2005-02-13 Thread ioannes
If you use LIMIT row_count with ORDER BY, MySQL ends the sorting as soon as it has found the first row_count lines rather than sorting the whole table. http://dev.mysql.com/doc/mysql/en/limit-optimization.html I need to get the top $num results from a completely sorted table (eg sorted on ID,

Re: [PHP-DB] MySQL: Top $num results

2005-02-13 Thread John Holmes
ioannes wrote: If you use LIMIT row_count with ORDER BY, MySQL ends the sorting as soon as it has found the first row_count lines rather than sorting the whole table. http://dev.mysql.com/doc/mysql/en/limit-optimization.html I need to get the top $num results from a completely sorted table (eg

[PHP-DB] 'Page can not be displayed' when hitting the back button

2005-02-13 Thread Jason Walker
I have a shopping cart that is working completely fine in Firefox. In I.E., I can not get the page to display when hitting the back button. This may not necessarily be a PHP problem, but since moving to PHP session variables and not cookies, this error has popped up. In Firefox, I get the

RE: [PHP-DB] 'Page can not be displayed' when hitting the back button

2005-02-13 Thread Jason Walker
In case anyone comes across this in the future, I finally found a solution to this: php.ini Find session.cache_limiter and make sure the setting is set to public or private. nocache was the problem. Does anyone have any concerns about this setting? I am looking around to see if this causes any