Re: numrows
| From: | Martin Kampherbeek | Date: | Thu, 23 Aug 2001 17:28:30 +0000 |
| Subject: | Re: numrows | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-64146@lists.php.net to get a copy of this message | ||
This is the error I get. I tested in MYSQLadmin and there it works. I think
there is something with numrows.
MySQL Query Failed. Error 1030: Got error -1 from table handler
Message-ID: <20010823171117.28544.qmail@web13408.mail.yahoo.com>
Date: Thu, 23 Aug 2001 10:11:17 -0700 (PDT)
From: "ERISEN, Mehmet Kamil" <erisen@yahoo.com>
To: php-general@lists.php.net
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Subject: Re: [PHP] numrows
Hello,
Chris, with all due respect, DESC is a reserved word for
SQL. is english ORDER BY ID DESC meand sort by id in
descending order.
Martin,
your SQL seems to be fine. Are you sure that you are
connected to your database.
I have run the following SQL against my database
SELECT *
FROM users
WHERE username <> '1'
AND user_id < 250
ORDER BY user_id DESC
and it returned back records. SO SQL syntax is fine.