| Roderik Emmerink 2005-01-15, 8:56 pm |
| Hi,
My phpMyAdmin does not show all records in the database when I choose
the browse tab for the table.
What I see is one record, which I inserted with phpMyAdmin itself.
Actually there are 3 records present (there must be, since 3 of them
will be returned when using SELECT * from within a php script).
I am not really happy with this behaviour, I want to see all
records/rows in my table that are present in the table. Below is some
information concerning the table:
Field Type Attributes Null Default Extra
ObjectType int(4) Yes NULL
Id int(6) UNSIGNED No auto_increment IsHidden
tinyint(1) Yes NULL IsPublished tinyint(1) Yes NULL
The query (browse tab):
SELECT *
FROM `Objects`
LIMIT 0 , 30
from phpMyAdmin returns just one record. The query:
SELECT *
FROM `Objects`
WHERE ObjectType =43
LIMIT 0 , 30
in phpMyAdmin this will return 0 records.
in php script this will return 2 records.
Please let me know what might be the reason that phpMyAdmin won't show
all rows.
regards,
Roderik
|