Re: [PHP-DB] Search witin text.

2007-02-11 Thread Christopher Blöcker
you can use explode from php.net: array *explode* ( string $delimiter, string $string [, int $limit] ) Returns an array of strings, each of which is a substring of /string/ formed by splitting it on boundaries formed by the string /delimiter/. If /limit/ is set, the returned array will

[PHP-DB] Search witin text.

2007-02-10 Thread Chris Carter
Hi, I have to send results to the users based on their search. Have got a combined serach option in which data is searched from two different fields and based on the match the result is sent or an error message (quite simple). Now I need to change this, the one column of data is from a VARCHAR

Re: [PHP-DB] Search witin text.

2007-02-10 Thread Micah Stevens
Send your query out on the list. That would give us something to work on. This should be very easy.. select * from tablename where column like '%$search%' or something of that nature. What are you doing? -Micah On 02/10/2007 08:49 PM, Chris Carter wrote: Hi, I have to send results to the

Re: [PHP-DB] Search witin text.

2007-02-10 Thread Chris Carter
Thanks much ... this has been achieved now. However, there is another issue. Say for example, the user wants to search 'Chriscarter' but puts into the search field 'Chris Carter' how is it that I can take only the 'Chris' out of the search string and present the matching searches from the