At 11:24 PM +0100 8/25/01, Carlos Pereira wrote:
>Hi,
>
>You are missing the ; at the end of the SQL statement
>try $query = "SELECT * FROM question WHERE answer<>'1' AND id>250 ORDER BY
>id;";
>instead of $query = "SELECT * FROM question WHERE answer<>'1' AND id>250
>ORDER BY id";
No. A semicolon statement terminator is a mysql convention, and is
not needed when issuing queries from within an API. For some APIs,
it will even cause queries to fail.
An error from the table handler may indicate a more serious problem,
perhaps requiring a table repair.
>
>CPereira
>
>----- Original Message -----
>From: "Martin Kampherbeek" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Saturday, August 25, 2001 8:17 AM
>Subject: Error
>
>
>> I still get this error. Can someone help me to solve this?
>> MySQL Query Failed. Error 1030: Got error -1 from table handler
>>
>>
>> $query = "SELECT * FROM question WHERE answer<>'1' AND id>250 ORDER BY
>id";
>>
>> $result = mysql_query($query) or die('MySQL Query Failed. Error
>> '.mysql_errno().':
>> '.mysql_error());
>>
> > $number = mysql_num_rows($result);
>>
> >
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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
