是说你MYSQL_QUERY返回的是一个无效的结果!所以什么都MYSQL_NUM_ROW不到啊!
还有:
$numresult=mysql_query("select *from book where class='$class'");
*from 中间没有空吗?写错了?
还有:
$numresult=mysql_query("select *from book where class='$class'");
*from 中间没有空吗?写错了?
@mysql_select_db("test",$conn);
$numresult=mysql_query("select * from book where class='$class'");
$num=mysql_num_rows($numresult);
我查询二个表,其中一个表名t_count,另一个表名t_member_info
t_count有40万条数据,t_member_info有3万条数据
当我执行这个查询语句时,语句如下!
select count(*) as counter,t_count.UserID,t_member_info.M_UnitName,t_member_info.M_Mail,findflag from t_count,t_member_info where t_member_info.M_UserID=t_count.UserID group by t_count.UserID order by counter desc limit 0,500出现的错误如下:
MySQL said: Got error 127 from table handler
我从来没遇到这种事情,希望高手指点,谢谢!
the meaning of it. In this case:[tim@mungbean tim]$ perror 127
Error code 127: Unknown error 127
127 = Record-file is crashedThen use Jake's suggestion :)> Check the status of your table by either using 'check table' or 'isamchk'
> ... it may have some connections that haven't been closed properly or has
> been corrupted.
>
> -----Original Message-----
> From: Celil Germeyan [mailto:<EMAIL: PROTECTED>]
> Sent: Wednesday, January 23, 2002 8:42 PM
> To: <EMAIL: PROTECTED>
> Subject: Got error 127 from table handler
>
>
> I started getting the following error after altering the table. Why would
> something like that happen??? I have not received such an error before
> eventhough I altered the table repeatedly.
>
> Your help is greatly appreciated.
> Thank you!
>
> java.sql.SQLException: null: Got error 127 from table handler----
Everyone talks about apathy, but no one does anything about it.
http://www.bitmechanic.com/mail-archives/mysql/May1997/0315.html