> If I run any select from the mysql prompt (SSH access) the results are > fine. > > It is only when I attempt this via a PHP script interface. I did a > couple samples queries where I changed the order (from desc to asc) and > set limits to around 97000-98000 from either direction with similar > results. It always breaks in that vicinity. With that many results, you're probably exceeding the memory limit or max execution time. http://us3.php.net/manual/en/ini.core.php#ini.memory-limit http://us3.php.net/manual/en/info.configuration.php#ini.max-execution-time Both of these can be set on a per-script basis using ini_set (http://us3.php.net/manual/en/function.ini-set.php). If you need to deal with that much data through PHP, you'll need to setup pagination so that it will be within reasonable memory/time/page load time limits. Brady