Re: web search form for a mysql database

2001-07-05 Thread chip . wiegand
-----Original Message----- FROM: [EMAIL PROTECTED] TO: [EMAIL PROTECTED] DATE: Thu 7/5/01 12:51 SUBJECT: Re: web search form for a mysql database For my needs, that would not be necessary, just a simple single word search. I now have to figure out how to integrate what Mr. Massey suggested into my

Re: web search form for a mysql database

2001-07-05 Thread massey
work. I guess I'm just stupid with mysql, I'm a newbie just trying to get something the marketing people want to work. -- Chip "Patrick J. Larkin" <[EMAIL PROTECTED]> on 07/05/2001 07:45:40 PM Internet mail from: To: MySQL List <[EMAIL PROTECTED]> cc: Subject:

Re: web search form for a mysql database

2001-07-05 Thread chip . wiegand
marketing people want to work. -- Chip "Patrick J. Larkin" <[EMAIL PROTECTED]> on 07/05/2001 07:45:40 PM Internet mail from: To: MySQL List <[EMAIL PROTECTED]> cc: Subject: Re: web search form for a mysql database What if you want to search for a number of terms? S

Re: web search form for a mysql database

2001-07-05 Thread massey
I think then you get into using Index's or FullText searchs http://www.mysql.com/doc/M/y/MySQL_indexes.html http://www.mysql.com/doc/F/u/Fulltext_Search.html -Original Message- FROM: Patrick J. Larkin TO: MySQL List DATE: Thu 7/5/01 11:51 SUBJECT: Re: web search form for a

Re: web search form for a mysql database

2001-07-05 Thread Patrick J. Larkin
What if you want to search for a number of terms? Say you have a database of common computer problems and solutions with a (simplifid) schema like this: Name Email Problem Solution Say you want to search on the Problem field. The Problem field would be strings of text like "Problem with aut

RE: web search form for a mysql database

2001-07-05 Thread massey
Here's a simple search in MySQL and PHP. Cheers M;-) Search.php3: Searching the Guest Book Searching the Database search for: Srch.php3: "; echo " Visit time and date User Name Last Name Email "; while ($r = mysql_fetch_array($result)) { // Begin while