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

Date: Thu, 23 Aug 2001 10:11:17 -0700 (PDT)
From: "ERISEN, Mehmet Kamil" <[EMAIL PROTECTED]>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Subject: Re: [PHP] numrows

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.

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
 FROM users
 WHERE username <> '1'
 AND user_id < 250
 ORDER BY user_id DESC
and it returned back records.  SO SQL syntax is fine.

PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to