Memo Blog

5/2/10
Sunday 2:12pm

Date Posted: 5/2/10

Spooky, but I figured out the direction I want to take, at least in part. I need to modify my queries. Here is an abridged query and what it would look like:

(select ID, title from anime WHERE (lcase( concat(cast(ID as char), summary, IFNULL(image,''))) LIKE '%e%' ))
UNION
(select ID, title from misc WHERE (lcase( concat(cast(ID as char), summary)) LIKE '%e%' ))
UNION
(select ID, title from manga WHERE (lcase( concat(cast(ID as char), summary, IFNULL(image,''))) LIKE '%e%' ))
order by ID asc limit 10

What is different about this query is that it combines all of the individual queries for each table into one query using UNION.

After I find out how to group the results by table and then sort by ID or date, I will start work on incorporating Ajax Pagination 1.2.2 and then I think that work on this script will be done.

If I do advance the script further it will be a completely new script that uses fulltext indexing, which is altogether different. The only reason I can see to write it would be if I had 10,000 times more data than I currently have in my database. Only really big websites have that large of a database.

I do not plan on going that route. Fulltext indexing may be handy, but it involves a huge sacrifice in user control.

EDIT: 3:06pm K, I figured out how to sort by table and then by ID. I can now begin some research on how to add some Ajax Pagination to the search program. Oddly enough this update will make the search script simpler, not more complicated.

It is nice to be making some progress on this script. It has certainly been a while and I have been contemplating how to proceed for weeks if not months.