Re: [PHP] Search thoughts

2008-07-19 Thread Richard Heyes
Mark Kelly wrote: Hi. On Saturday 19 July 2008, Richard Heyes wrote: Currently the site in question uses a very basic LIKE in MySQL, eg %blah%, but naturally this finds terms such as hjkblahbjkk - which is not desired. Or such matches should be ranked lower than something that matches the

Re: [PHP] Search thoughts

2008-07-19 Thread tedd
At 10:47 AM +0100 7/19/08, Richard Heyes wrote: Hey, I was hoping to get some ideas on improving a sites search. Currently I have two - not a lot but I've been thinking about this for a few minutes. That'll leave a mark. :-) Currently the site in question uses a very basic LIKE in MySQL,

Re: [PHP] Search thoughts

2008-07-19 Thread Richard Heyes
I'm sure that would work, but just how many LIKE items do you want to show the user? For me, I would rather not show them anything if there is nothing on my site that matches their exact search criteria. Certainly an idea, but something like We also found... might be helpful in regard to

Re: [PHP] Search thoughts

2008-07-19 Thread Mark Kelly
Hi. Just noticed I replied direct rather than to the list last time, sorry about that. On Saturday 19 July 2008, Richard Heyes wrote: How much traffic do you have and what's your hardware? Are your queries cached and subsequently repeated? Do you pre cache common queries? I've done this kind

Re: [PHP] Search thoughts

2008-07-19 Thread Eric Butera
On Sat, Jul 19, 2008 at 5:47 AM, Richard Heyes [EMAIL PROTECTED] wrote: Hey, I was hoping to get some ideas on improving a sites search. Currently I have two - not a lot but I've been thinking about this for a few minutes. Currently the site in question uses a very basic LIKE in MySQL, eg

Re: [PHP] Search thoughts

2008-07-19 Thread Richard Heyes
Ever play with fulltext search? Yes, though it's not suitable in this instance. -- Richard Heyes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Search thoughts

2008-07-19 Thread tedd
At 1:56 PM -0400 7/19/08, Eric Butera wrote: Ever play with fulltext search? Never in public. :-) You could throw all text into your database and then do a fulltext search to give back the related pages -- that would work. I think I saw that as an example in one of the books I read. PHP

Re: [PHP] Search thoughts

2008-07-19 Thread Eric Butera
On Sat, Jul 19, 2008 at 3:40 PM, tedd [EMAIL PROTECTED] wrote: At 1:56 PM -0400 7/19/08, Eric Butera wrote: Ever play with fulltext search? Never in public. :-) You could throw all text into your database and then do a fulltext search to give back the related pages -- that would work. I

Re: [PHP] Search thoughts

2008-07-19 Thread Richard Heyes
the entire King James Bible in a dB -- interesting read That's debateable... :-) -- Richard Heyes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Search thoughts

2008-07-19 Thread Richard Heyes
Hi, I've been playing around with the zend search lucene and it is really powerful too. Worth looking into? -- Richard Heyes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Search thoughts

2008-07-19 Thread Eric Butera
On Sat, Jul 19, 2008 at 4:06 PM, Richard Heyes [EMAIL PROTECTED] wrote: Hi, I've been playing around with the zend search lucene and it is really powerful too. Worth looking into? -- Richard Heyes Most definitely. But with all that power and optional stuff comes complexity too. It

Re: [PHP] Search thoughts

2008-07-19 Thread Richard Heyes
http://framework.zend.com/manual/en/zend.search.lucene.html Nice one, thanks. -- Richard Heyes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php