I agree, tedd. And your points about what makes sense are taken.
That being said, the end point of all this is for a search to simply
act like a real person turning the pages of a phone book.
All I need to do is take the user to a desired point within the
records in the database. This is by request of the client I'm working
for, not what makes sense. (As you may well know, these two don't
always meet. lol)
At this point, it seems to me that in order to achieve my desired
result, I need to incorporate an auto-incremented ID column in the
table so that this value may be used to calculate the number of
records before the found record.(ie, if the found record's ID is 201,
then there were 200 records before it. Divide 200 by 100 records per
page and the desired result is on page 3.)
Assuming no one else sees a method to achieve the desired result
without such a change.
Thank you, tedd, for your input. It does help to have someone
--
T.J. Mahaffey
tj@xxxxxxxxxxxxxx
On Dec 23, 2006, at 10:05 AM, tedd wrote:
tj:
In my opinion, wrong thinking. You ask how many records appear
before and after a search string result. That's like asking "What's
the difference between an orange?" -- it doesn't make sense.
The user enters a search string. All records are searched and the
correct one is found and presented. Now you want the records that
were not correct to be arranged in some manner of before and after
correctness -- it doesn't make sense.
You could use a FULL TEXT search in order of relevance, much like
what search engines do. But those searches come back with correct
searches and then sort them in terms of relevance. They don't show
the correct record and then all the records that were before and
after correctness. Do you see what I mean?
You could put in a field that has a number assigned to it, and show
what numbers came before and after the record selected (like
sequence of entry, auto-incrementing ID ), but that isn't relevant
to the original search criteria.
You need to think about what you specifically want to show the user
-- what would make sense, or of use, to them?
hth's
tedd
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
