how to search database for similar title

rpsep2

hello,

I'm displaying an image which has been uploaded by a user.
I want to display similar uploads in the sidebar, based on the title.

for example, if the current post has a title of 'a photo of trees', id like to display results that have a similar title. I realise words like 'a' and 'of' are very common, so is there a way to strip out only words that are say 3+ characters long? i.e display results that have a title containing 'photo' and/or 'trees'

Im using the LIKE query elsewhere, but if i use it here I get no results as the database is obviously searching for a whole title that contains the current title..( using LIKE '%$title%' at the moment)

thanks for any help

vivek151189

you can post your some code so that we can understand it and help you

rpsep2

bradgrafelman;11003664 wrote:
Have you considered doing a Full-Text Search? Not only would this allow you to match rows that are related to the search term (but don't necessary contain it verbatim), but MySQL also by default skips over words that are less than four characters in length for fulltext indexes. (See Fine-Tuning MySQL Full-Text Search and the ft_min_word_len MySQL server system variable.)

worked like a charm thank you 🙂

another question though; How would I go about making sure i dont get the current upload in the results? as obviously the title is an exact for the query

using this query currently if it helps:

$sql =("SELECT * FROM uploads WHERE MATCH(title) AGAINST('$title') LIMIT 0,3") or die(mysql_error());
   $result = mysql_query($sql); 
   while($display = mysql_fetch_array($result)){

then the loop goes through the results and displays in the sidebar

Derokorian

add a where clause to ignore the current record, or do the select before you insert the new record.

rpsep2

Derokorian;11003690 wrote:
add a where clause to ignore the current record, or do the select before you insert the new record.

thanks for quick reply. How do i add a where clause to exclude a result? I'm only used to using a where clause to include a result i.e WHERE title='$title'

oh nevermind having a dumb moment! title !='$title' obviously