I have a table where users insert table via a form (this is done through a Joomla module). When I view that table in phpmyadmin, it only returns 73 rows. Yet when I view the data via the module itself (there is an output portion), there are 140 rows... which is what I am expecting. I even looked at the mysql schema tables and it only sees the 73 rows. Yet I even installed another module that pulls data based on SQL queries and THAT module also sees the 140 rows.
Does anyone know why phpmyadmin or my own PHP script on another page would not see all of the records? I already tried repairing, flushing, and optimizing the table... all to no avail. I'm running out of ideas.