phpMyAdmin - doesn't show select results

Question

My phpMyAdmin installation seems to be working just fine. I can handle databases and tables and insert datasets in tables.

But I cannot see the datasets in the tables. If I try to let it show the datasets by selecting "Browse" in the table-navigation, I get the following message:

Showing rows 0 - 0 ( 1 total, Query took 0.0061 sec)

BUT the table remains empty and no error messages appear.

I can get the data using php.

• PHP Version: 5.2.6
• MySQL Version: 5.0.45
• phpMyAdmin Version: 3.5.3

Answer 1

phpMyAdmin dosn't allow you to browse empty tables. A big red cross over Browse on top tab or disabled. So if Browse is avilable in phpMyAdmin what is the problem. A few times I have browsed a table with only 1 record and I thought I was not getting a result. In my hurry I didn't realize there was a record showing. A 1 row record is easyly missed.

Hope this helps