lotus Posted May 21, 2008 Share Posted May 21, 2008 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 More sharing options...
PFMaBiSmAd Posted May 21, 2008 Share Posted May 21, 2008 Posting your table definition would help. Link to comment https://forums.phpfreaks.com/topic/106582-cant-see-al-records/#findComment-546433 Share on other sites More sharing options...
lotus Posted May 22, 2008 Author Share Posted May 22, 2008 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 More sharing options...
fenway Posted May 22, 2008 Share Posted May 22, 2008 What is "it" in "it displays"? Link to comment https://forums.phpfreaks.com/topic/106582-cant-see-al-records/#findComment-547398 Share on other sites More sharing options...
lotus Posted May 23, 2008 Author Share Posted May 23, 2008 I didnot understood your question? elaborate it Link to comment https://forums.phpfreaks.com/topic/106582-cant-see-al-records/#findComment-547886 Share on other sites More sharing options...
fenway Posted May 23, 2008 Share Posted May 23, 2008 When i see the no. of records it says 150. However it displays only 129 records How are you detemining these numbers? Link to comment https://forums.phpfreaks.com/topic/106582-cant-see-al-records/#findComment-548162 Share on other sites More sharing options...
lotus Posted May 26, 2008 Author Share Posted May 26, 2008 firstly if you see the records in my-sql front it displays no. of records 2ndly i have cheked it by select count(*) from tablename; to get the no. of records Link to comment https://forums.phpfreaks.com/topic/106582-cant-see-al-records/#findComment-550009 Share on other sites More sharing options...
lotus Posted May 29, 2008 Author Share Posted May 29, 2008 i have exported the records into an sql file. droped the table n then againg created it. then imported the records Atleast til now its workng fine without any problem Link to comment https://forums.phpfreaks.com/topic/106582-cant-see-al-records/#findComment-552310 Share on other sites More sharing options...
ireneyee Posted May 29, 2008 Share Posted May 29, 2008 can post ur codes so that we can have a better idea?? Link to comment https://forums.phpfreaks.com/topic/106582-cant-see-al-records/#findComment-552311 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.