-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
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:
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
uot;%";
> $query = "select * from visitors WHERE Name LIKE '$srch' || Last LIKE '$srch'
> || email LIKE '$srch' || comment LIKE '$srch'";
>
> $result = mysql_db_query("guest_book", $query);
>
> if ($result)
> {
> echo "He
";
> $query = "select * from visitors WHERE Name LIKE '$srch' || Last LIKE '$srch'
> || email LIKE '$srch' || comment LIKE '$srch'";
>
> $result = mysql_db_query("guest_book", $query);
>
> if ($result)
> {
> echo "Here ar
uot;];
$last = $r["Last"];
$email = $r["email"];
$comment = $r["comment"];
echo "
$ts
$name
$last
$email
$comment
";
} // end while
echo "";
} else { echo "problems"; }
} else {
echo "Search string is empty. Go back and type a st
I have mysql 3.23.38, php4.03, apache1.3.14. I have a small database of
dealer bulletins.
I have created a web page to allow easy input of new bulletins into the
database, and a second
web page to display those bulletins. On this page are links to allow
displaying the bulletins
in several differan
