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?
Thankyou,
Chip Wiegand
Computer Services
www.simradusa.com
[EMAIL PROTECTED]
Simrad, Inc
Lynnwood, WA
425-712-1138
"There is no reason anyone would want a computer in their home."
--Ken Olson, president, chairman and founder of Digital Equipment Corp.,
1977
(-- Then why do I have nine? Somebody help me!)
---------------------------------------------------------------------
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