sage-
> > From: mike karthauser [mailto:[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 keywo
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, t
mailto:[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
$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
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 so