Sorting a search by relevance

[Anon]

How do you do this?

[Anon]

I dunno how much this helps, but you can get your query returned sorted by a paricular column in your db by using ORDER BY in your SELECT query.

EG: Say you have a column in your db called date and you wanted your query sorted by the date then you use:

SELECT * FROM dbname ORDER BY date;

thats it. CHeck out the section in the documentation on ORDER BY.

Vikesh.

[Anon]

There's a good example of doing this
at http://www.devshed.com in the PHP section.

I works pretty good and it's very FAST!.

hope this help.

[irf2k]

id appreciate if you could give me the exact URL, because i went there and could not find the page. Thanx.