Re: Difficulties in handling LIMIT queries

Sorry guys ... I am using MySQL with PHP under Apache (Linux and NT). Thanks in advance, Joao ------------------------------------------------------------- Joao Barreto Fernandes - e-Business, Security, Accounting & Billing CONVEX Portugal - Informática e Sistemas de Comunicações, Lda Edf. Inovação III, 624 - 2780-920 Porto Salvo - Portugal barreto@convex.pt http://www.convex.pt +351 214229200 ----- Original Message ----- From: João Barreto Fernandes <barreto@convex.pt> To: <php-db@lists.php.net> Sent: Sexta-feira, 11 de Agosto de 2000 14:55 Subject: [PHP-DB] Difficulties in handling LIMIT queries > Hi all ... > > I have a simple that many of you might find extremelly simple to answer. > > I have a DB with a table with around 50.000 rows. When I do a query > that gives me back around 15.000 rows, I have no problems in using > LIMIT x,y to get only a few of them. If a use some ordering I only get > back some values if the query (without the order by) would give me > back no so many rows. > > The error I get is 1114: The table 'SQL4677_0' is full > > Any ideas or workarounds? I am using indexes on the order columns. > > Thanks in advance, > Joao > ------------------------------------------------------------- > Joao Barreto Fernandes - e-Business, Security, Accounting & Billing > CONVEX Portugal - Informática e Sistemas de Comunicações, Lda > Edf. Inovação III, 624 - 2780-920 Porto Salvo - Portugal > barreto@convex.pt http://www.convex.pt +351 214229200 > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >