I see... if adding "ORDER BY articleId DESC LIMIT 0, 20" causes a query to
start returning 0 rows, then that sounds like something is wrong.
Try using the REPAIR TABLE command on all your tables from inside MySQL,
e.g.:
REPAIR TABLE article;
REPAIR TABLE asubject;
REPAIR TABLE atype;
REPAIR TABLE author;
REPAIR TABLE source;
REPAIR TABLE user;
If there is corruption in the tables, that might be causing the problem.
Other than that, I am out of ideas...
On Tue, 4 Sep 2001, [EMAIL PROTECTED] wrote:
> >Use this instead:
> >ORDER BY articleId DESC LIMIT 0, 20
>
> That is not a problem as first parameter is just offset. But I have also
> tested with 0, but still the same problem.
>
> Secondly even if the no. of rows returned are greater then 20 there is a
> same error message , while running from phpadmin.
>
> Have you ever faced this problem , with order by and limit?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
