Many Thanks for your quick reply.
The MySQL version is 3.22 on Unix/FreeBSD/Apache.
thanks
At 08:43 AM 5/2/02 -0500, Gerald Clark wrote:
>Unfortunately, you did not tell us what version you are running, or what
>platform you are running it on.
>
>
>Try rebuilding the indexes with myisamchk or whatever is appropriate for
>your table type.
>
>Sheni R. Meledath wrote:
>
>>Hello:
>>
>>I have a problem while selecting the records from a table. This table has
>>got 15494 records. But when selecting its displaying only 1745 records.
>>
>>###
>>$result=mysql_query("SELECT COUNT(*) as numrows FROM $table2");
>>$row=mysql_fetch_array($result);
>>$num_rows2 = $row[numrows];
>>echo $num_rows2;
>>=15494
>>
>>$result=mysql_query("select * from $table2");
>>$num_rows1=mysql_num_rows($result);
>>echo $num_rows1;
>>=1745
>>
>>###
>>
>>Using the second command I can't display all the records.
>>
>>But using separate select statement I can select & display any record
>>which is not displayed in the above case.
>>###
>>$result=mysql_query("select * from $table2 where id='15000'");
>>$row=mysql_fetch_array($result);
>>echo $row[name];
>>=sheni
>>###
>>
>>Could you please help me to figure it out.
>>
>>Regards
>>
>>Sheni R Meledath
>>[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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>
>
Sheni R Meledath
[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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
