Re: How to do freeform text search across multiple fields ??

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




What I wanna do is make it possible to search for partial content in
model,variant, and type fields, all 3 at the same time, or each individually
as the user wants...case insentive too ...

<? //assuming you got a POST from the form :) reset ($_POST); while (list ($key, $val) = each ($_POST)) { $$key = $val; }

if(!(empty($model))) {
        $searchstring .= " AND model LIKE '$model'";
}
if(!(empty($variant))) {
        $searchstring .= " AND variant LIKE '$variant'";
}
if(!(empty($fields))) {
        $searchstring .= " AND fields LIKE '$fields'";
}

$query = "SELECT * FROM cpu WHERE cpuID <> '0' $searchstring ORDER BY cpuID";
$connection = mysql_connect($HOST, $USERNAME, $PASSWORD);
$SelectedDB = mysql_select_db($DBNAME);
$result = mysql_query($query);


//etc.
?>

It's a bit quick and dirty, because you need something like the cpuID <> '0' to make this to work. But its a start right ;)


laters,


Fedde

~= The sum of the intelligence on the planet is a constant; the population is growing. =~

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux