Hi,
I'm not really sure which is the best path to go but let me give you an example
scenario :
1. We already have a database of varchar data :
+-------------------------------------------+
| links |
+-------------------------------------------+
| 340-golfers-dream-and-swimmers|
+-------------------------------------------+
| 89-golfers-dream |
+-------------------------------------------+
| 45-golf-equipments |
+-------------------------------------------+
| 3-best-golf-training |
+-------------------------------------------+
| 0-golf-equipment-and-training |
+-------------------------------------------+
| 39-golf-training |
+-------------------------------------------+
2. From data above if we search the database for '%golf%' it would return all
rows as results, if we search for '%golf%training%' it would return three rows .
How do I choose from the multiple results? For the '%golf%' query, the desired
result is golf-equipments or golf-training, while for '%golf%training%' the
desired result should be 39-golf-training alone . This is sort of like search
engine ranking their results, but for this how do I set the criteria using MySQL
queries or if not possible using PHP .
I hope it makes it more clear, questions are welcomed.
TIA
Jervin
--
> Outsource Now | GetAFreelancer
<http://www.getafreelancer.com/affiliates/shockx/>
_____
From: Shafiq Rehman [mailto:rehmanms@xxxxxxxxx]
Sent: Tuesday, December 19, 2006 2:07 PM
To: zoticaic
Subject: Re: Search Results Accuracy
Hello,
Your question is not very clear, please elaborate it.
btw, Are you talking about the fulltext search?
--
Shafiq Rehman
Sr. Web Engineer
http://www.phpgurru.com <http://www.phpgurru.com>
On 12/19/06, zoticaic <zoticaicpassion@xxxxxxxxx> wrote:
Hello,
I'm just wondering, from a list of search results from a database query, how do
we trim down and return the most accurate one?
Hints, links and suggestions are most welcome.
TIA
Jervin
--
> Outsource Now | GetAFreelancer
<http://www.getafreelancer.com/affiliates/shockx/>
