Puremin0rez
New Member
I have an area which gets populated with about 100 records from a php mysql query.Need to add ajax pagination meaning to load 10 records first, then on user click to let's say "+" character it populates the next 20.So the area instead of displaying all at once will display 20, then on click, then next 20, the next... and so on with no refresh.Should I dump the 100 records on a session variable?Should I call Myqsl query every time user clicks on next page trigger?Unsure what will be the best aproach...or way to go around this.My concern is the database will be growing from 100 to 10,000.Any help direction is greatly apreciated.