• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
CI FULLTEXT pagination

#1
[eluser]smartweb[/eluser]
Hi,
I have a database, which has 1.5 million records. I need to constantly query the database and generates the paging record. Who can tell me how to write the T-the sql?

The table structure is as follows

CREATE TABLE IF NOT EXISTS `test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(200) DEFAULT NULL,
`body` text,
PRIMARY KEY (`id`),
FULLTEXT KEY `title` (`title`,`body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=86 ;


Messages In This Thread
CI FULLTEXT pagination - by El Forum - 05-21-2012, 06:05 AM
CI FULLTEXT pagination - by El Forum - 05-21-2012, 06:29 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.