I am developing a site which shows tv schedules online...
http://www.einFotimes.com I want to add search to it.
Basically i want to know how to full text search through all the tables
in database and i also want the name of table in result along with
fields...is it possible?
Dasmeet
--
PHP D
The query you would need would be something along the lines of:
SELECT show_name FROM table_of_shows WHERE show_name LIKE '%$keyword%'
Learning the LIKE syntax is going to be the best help to you in this situation, I
believe ;o)
Martin Clifford
Homepage: http://www.completesource.net
Developer
Martin Clifford wrote:
> The query you would need would be something along the lines of:
>
> SELECT show_name FROM table_of_shows WHERE show_name LIKE '%$keyword%'
>
> Learning the LIKE syntax is going to be the best help to you in this situation, I
>believe ;o)
Thanx, I am already using 'Like'
cc:
Subject: Re: [PHP-DB] How to use Full
text search?
07/18/2002
name FROM table_of_shows WHERE show_name like '%simpsons%' OR
>show_name like '%sienfeld%' etc
>
>Hope this helps.
>Jeff
>
>
>
>
> Dasmeet
> Singh
>
>
> il.com>
c
>>
>> Hope this helps.
>> Jeff
>>
>>
>>
>>
>> Dasmeet Singh
>> > il.com> cc:
>> Subject: Re: [PHP-DB] How
>> to use Full text search?
>>
%' OR
>>>show_name like '%sienfeld%' etc
>>>
>>>Hope this helps.
>>>Jeff
>>>
>>>
>>>
>>>
>>> Dasmeet Singh
>>> >> il.com>