on 18/12/02 5:47 pm, Adam Voigt at [EMAIL PROTECTED] wrote:
$searchstring = $_POST[searchfor];
$searchstring = str_replace( ,%,$searchstring);
mssql_query(SELECT id FROM table WHERE field LIKE '$searchstring';);
I've modified my query to
$result = mysql_query(SELECT coursecode, title FROM
I'm looking for tips and tricks in how to approach building a keyword search
over an number of fields in a courses database.
I know how i can search for one word at a time, but i am not sure on how i
would approach searching via a defined string.
Anyone got any good pointers for doing this/ or
$searchstring = $_POST[searchfor];
$searchstring = str_replace( ,%,$searchstring);
mssql_query(SELECT id FROM table WHERE field LIKE '$searchstring';);
This will give you a looser search where all search terms have
to be there, but not necessarily next to each other, if you want a
:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 12:44 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] keyword search a mysql database.
I'm looking for tips and tricks in how to approach building a keyword
search
over an number of fields in a courses database.
I know how i can search for one
