Some search engine questions....

From: Date: Thu, 01 Mar 2001 18:23:32 +0000
Subject: Some search engine questions....
Groups: php.general 
Request: Send a blank email to php-general+get-42204@lists.php.net to get a copy of this message
Hey guys, I've got a question regarding a search engine I have to write.... Basically what I have is this.. I have a table with a serialized array in it. I'd like to take that array and search for keywords... I've got a mySQL database and this is how I'm doing it... SELECT a FROM b,c WHERE(b.serializedarray LIKE CONCAT('%', c.keywords,'%')); Where b is the table containing the serialized data and c is a single column HEAP table with the list of keywords... Now... My question is kind of two fold... A) Is this the best way to do it? By Best I mean considering I am dealing with a serialized array.... and - thiis is my real question B) How do I show limited page results? I want to break up the results into groups of 5 per page and have x pages (count % 5). My problem is that the origional query gets lost once the page has returned the first set of results and I have no real way of keeping them... There can be too many to append to the <A HREF> of the link to the next page and I don't want to use form POSTS since I have to have buttons for all of them.... Any suggestions? John

« previous php.general (#42204) next »