On Tue, 3 Jul 2001 01:53, [EMAIL PROTECTED] wrote:
> I have a database of dealer bulletins. I have a web page that shows the
> results of sorting
> the info in the database in certain ways. I also want to add a field to
> the page to allow the
> user to input a search word(s) and have the results displayed. I can't
> find the answer to this
> in the docs on the mysql site, I tried to search the archive, but it is
> soooo slow I gave up on
> that. So, here's what I have, a few else/elseif's to handle the
> sorting, plus this line
>
> elseif ($orderby == 'request'):
> $sql = "select bulletin_number,bulletin_subject from bulletin where
> match (body,bulletin_subject) against ('request')";
>
> I want 'request' to be the variable from the form input=text field.
> Does mysql have something similar to perl's $variable=<STDIN>? Just how
> do I do this type of search?
That looks like PHP scripting (and probably eighteen other languages as
well)
If PHP, then if INPUT TYPE=text has the name request, it's value will be
in $request.
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
A cat will go "quack" - if you squeeze it hard enough.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
