Wednesday, 28 August 2013

phpmyadmin error code 500 when try to access table

phpmyadmin error code 500 when try to access table

There are 65 tables in my database. All are working fine when I try to
access them in phpmyadmin.
However, I faced a problem when I try to access one of the table (300
column) in my localhost. It show me the error message like below. The
table has 262 data inside. I had no problem to access the table in my live
server.
NOTE : However, if I insert query like select * from my_table where id=100
in phpmyadmin the table will return a result for me. But if the query is
select * from my_table then it will prompt me the error.
I tried the following code in php. And it did return all the IDs.
$query="select * from my_table";
$result=mysql_query($query) or die (mysql_error());
while ($row=mysql_fetch_array($result))
{
echo "ID-".$row['id']."<br/>";
}
Even I drop the table and import again from my live server same problem
existed. Is it because my localhost phpmyadmin cant support/show such a
huge table (262 data with 300 column each)?

No comments:

Post a Comment