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 differant sort orders. This all works just fine. I was asked to
also add a search field.
I have searched the online docs but cannot find an answer to this: how do I
get a user inputted
reqest into the mysql query string? Here's what I have tried most recently:
(lots of snipped code)
<form action="bulletin_sorter.php" name="form1">
Enter a search word(s): <input type="text" name="body">
<INPUT TYPE="hidden" NAME="orderby" VALUE="request"> </form>
(lots of snippage)
elseif
($orderby == 'request'):
$sql = "select * from bulletin where match (bulletin_subject,body) against '$request'";
(lots more snippage)
I have tried variations on the above query statement, none of which would work. I can
do this
without any problem from the mysql command line by entering the word I am interested in
searching on. The problem seems to be with the part after against, just how do I get
the user
input data into that field?
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
