Cant see al records

[lotus]

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.

[PFMaBiSmAd]

Posting your table definition would help.

[lotus]

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;

 

 

[fenway]

What is "it" in "it displays"?

[lotus]

I didnot understood your question?

elaborate it

[fenway]

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

However it displays only 129 records

How are you detemining these numbers?

[lotus]

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

 

 

[lotus]

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

[ireneyee]

can post ur codes so that we can have a better idea??