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. =~