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