[BNM] Suggest in search - way of doing with MySQL?

[Ali]

http://www.brandspankingnew.net/archive/2006/08/ajax_auto-suggest_auto-compl
ete.html

any good? Been thinking of doing something like this now also - one extra
dimension I am thinking of is storing common searches as a pool to draw from
(ordered by success factor) and drawing on that - I suppose the
accessible/degraded fallback would be, as you suggest, the same sort of
suggestions on the results page.

The levenshtein procedure Jamie mentions -seems a good solution to the
suggestion logic...

hth

Ali

-----Original Message-----
From: bnmlist-bounces at brightonnewmedia.org
[mailto:bnmlist-bounces at brightonnewmedia.org] On Behalf Of Paul Silver
Sent: 02 October 2008 10:34
To: Brighton New Media list
Subject: [BNM] Suggest in search - way of doing with MySQL?

Hi,

I'm making a search within a database driven site soon. We'd like to be
able to suggest corrections or just show results for the suggestions if
nothing is returned from a straight search.

E.g. visitor searches for "bananas in pijamas"

Results say: "No results for 'bananas in pijamas', would you like to
search for 'banans in pyjamas'"

Is there an easy way of doing this with PHP 5 & MySQL 5? 

Thanks

Paul
-- 
  Paul Silver - tel: 01273 906020 or mobile: 07813 654285
  Web Development: http://www.paulsilver.co.uk
  Search Engine Promotion: http://webpositioningcentre.co.uk   
  Check your web pages: http://www.spidertest.com

-- 

BNM Subscribe/Unsubscribe:
http://www.brightonnewmedia.org/options/bnmlist

BNM powered by Wessex Networks:
http://www.wessexnetworks.com
No virus found in this incoming message.
Checked by AVG - http://www.avg.com 
Version: 8.0.173 / Virus Database: 270.7.5/1701 - Release Date: 01/10/2008
09:05