Hey, I figured I was making a nightmare goulash out of it, but with
limited knowledge and few examples I could find, it is what I came up
with, back in yonder times. Probably why I am questioning it's viability
now.
I understand offset and limit in SQL. Perhaps, like this example
<http://www.onlamp.com/pub/a/php/2002/10/24/simplesearchengine.html?page=1>
on O'Reillly's site. I need to create a words table, an occurrence
table, and a page/location table of some sort, and instead of displaying
a link to the product, in the summary, an image link.
It is amazing the rubber bands and bubblegum that can be strung together
when the proper methods are hard to find. I think a year or two ago I
asked similar questions and looked for books, but didn't really come up
with a better solution.
Glad that maybe this time around I can simplify my life with indexing.
Thanks,
-Brian
[...]
Richard Lynch wrote:
You are making a nightmare out of something that is very very simple. :-)
Just put the sorting and filtering and paging into the SQL queries,
and be done with it.
If your database is properly indexed, it will be "just as fast" as
this convoluted solution you are attempting to devise, and done in
about 3 lines of code instead of thousands.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
