Re: [PHP] About Website Search Engine

2007-07-18 Thread Nathan Nobbe
late follow up on this, but i was poking around php.net the other day and stumbled upon this: http://www.xapian.org/ -nathan On 7/6/07, tedd [EMAIL PROTECTED] wrote: At 1:34 PM -0700 7/5/07, Kelvin Park wrote: I'm trying to build a search engine for my website (with php), it will have

Re: [PHP] About Website Search Engine

2007-07-06 Thread tedd
At 1:34 PM -0700 7/5/07, Kelvin Park wrote: I'm trying to build a search engine for my website (with php), it will have functions such as finding product names and their codes from the mysql database. Does anyone know any good tutorial or reference on any website, or any good books out there

[PHP] About Website Search Engine

2007-07-05 Thread Kelvin Park
I'm trying to build a search engine for my website (with php), it will have functions such as finding product names and their codes from the mysql database. Does anyone know any good tutorial or reference on any website, or any good books out there that you might recommend? I couldnt' find any

Re: [PHP] About Website Search Engine

2007-07-05 Thread Daniel Brown
On 7/5/07, Kelvin Park [EMAIL PROTECTED] wrote: I'm trying to build a search engine for my website (with php), it will have functions such as finding product names and their codes from the mysql database. Does anyone know any good tutorial or reference on any website, or any good books out there

Re: [PHP] About Website Search Engine

2007-07-05 Thread Daniel Brown
On 7/5/07, Kelvin Park [EMAIL PROTECTED] wrote: Yes my website is dynamically driven from content within mysql. The products and the product information is within the datase. I was looking for a way to allow people to efficiently search for an item, for example if a customer types in, bunny, it

Re: [PHP] About Website Search Engine

2007-07-05 Thread Nathan Nobbe
Kevin, just like Daniel said, $sql .= OR product_description *LIKE '%.$terms.%'*; most of the *search engines* ive seen revolve around the use of the LIKE constructhttp://dev.mysql.com/doc/refman/5.1/en/string-comparison-functions.html#operator_like which is a simplified regex mechanism for

Re: [PHP] About Website Search Engine

2007-07-05 Thread Robert Cummings
On Thu, 2007-07-05 at 22:26 -0400, Nathan Nobbe wrote: Kevin, just like Daniel said, $sql .= OR product_description *LIKE '%.$terms.%'*; most of the *search engines* ive seen revolve around the use of the LIKE

Re: [PHP] About Website Search Engine

2007-07-05 Thread Nathan Nobbe
note: i never said this was an optimal solution; i just said thats what ive seen. obviously i havent worked on any major search engine to date. in fact i was fishing a bit for some info on how to do it right. On 7/5/07, Robert Cummings [EMAIL PROTECTED] wrote: If you need to use MySQL use the