Jump to content

Cant see al records


lotus

Recommended Posts

I have entered almost 150 records in a tabe of my databasde.

I am using MySql database and front end of mysql for records entry.

When i see the no. of records it says 150.

However it displays only 129 records

If i add more records it adds to the total no. of records, but doesnt display me the newly added records after 129. I have tried for both from query as wel as view data button.Similarly when i enter data of an existing record that it is not showing after 129 (e.g 135) , it gives error of duplict etry.

 

One more thing that when i export the data to some other file or database, it only copies 129 records to the file.

Link to comment
https://forums.phpfreaks.com/topic/106582-cant-see-al-records/
Share on other sites

CREATE TABLE `childcarecenter` (

  `RegId` varchar(12) NOT NULL default '0',

  `StdName` varchar(50) default NULL,

  `FdName` varchar(50) default NULL,

  `GardOcu` varchar(100) default NULL,

  `Age` int(2) default NULL,

  `FMembers` char(3) default NULL,

  `AdmDate` date default NULL,

  `Gender` varchar(6) default NULL,

  `Address` varchar(255) default NULL,

  `NatureWork` varchar(100) default NULL,

  `Religion` varchar(12) NOT NULL default '',

  `PlaceWork` varchar(100) default NULL,

  `WorkingHours` varchar(10) default NULL,

  `WorkingAdd` varchar(100) default NULL,

  `Granted` varchar(5) default NULL,

  `CId` int(3) default NULL,

  `Comments` varchar(100) default NULL,

  `Contact` varchar(100) default NULL,

  `LeavingDate` date default NULL,

  PRIMARY KEY  (`RegId`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

 

Link to comment
https://forums.phpfreaks.com/topic/106582-cant-see-al-records/#findComment-547271
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.