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. Quote 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. Quote 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; Quote 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"? Quote 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 Quote 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? Quote 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 Quote 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 Quote 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?? Quote Link to comment https://forums.phpfreaks.com/topic/106582-cant-see-al-records/#findComment-552311 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.