|
Perl mysql question
Hey,
Right now I have a script that works well and displays everything I want exactly as I want it.
But since some of my own stuff is inside my sql database, I want to advertise mine first if the search matches.
Basically, the surfer enters a search string and then based on how many words are used, it searches the database and displays all the results accordingly.
What I want is to give priority to my own. Lets say someone searches for "carrots" and "beans". My script will find everything that matches carrots and beans.
If one of my own has that description, I want it to be displayed first while not overwriting the real first results.
Anyone have any idea how to do this?
Thanks in advance,
Jon
|