cowhi
cowhi

Reputation: 2215

phpMyAdmin - doesn't show select results

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.

Upvotes: 5

Views: 4809

Answers (2)

zixtor
zixtor

Reputation: 241

I can't reproduce the problem in phpMyAdmin 3.5.4, nor in 4.0. The data should be visible if it's there.

Could you provide the table structure you used?

Anyway, you should update to some newer version, probably 4.0 or later. Feel free to report the issue on http://sourceforge.net/p/phpmyadmin/bugs

Upvotes: 1

david strachan
david strachan

Reputation: 7228

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.

enter image description here

Hope this helps

Upvotes: 3

Related Questions