View Single Post
Old 09-22-2004, 02:09 PM  
archael
Registered User
 
Join Date: Jun 2003
Posts: 51
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
archael is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote