query(“SHOW COLUMNS FROM searches;”);
$clauses = ”;
$key = ”;
$param_arg_list = ”;
$param_arg_list[0] = ”;
$param_arg_values = array();
$input = ”;
if (array_key_exists(‘q’, $_GET) &&
strlen($_GET[‘q’]) > 0)
$input = $_GET[‘q’];
if (array_key_exists(‘search-criteria’, $_GET) &&
strlen($_GET[‘search-criteria’]) > 0)
$input = $_GET[‘search-criteria’];
$input = mysql_real_escape_string($input);
$input = strtoupper($input);
while ($row = $result->fetch_array())
{
if ($key === ”)
$key = $row[0];
$clauses .= “{$row[0]} = ‘{$input}’ OR “;
}
$clauses = substr($clauses, 0, -4);
$sql = “SELECT * FROM searches WHERE {$clauses} GROUP BY {$key} ORDER BY {$key};”;
$result = $conn->query( $sql );
?>
Manufacturer Part Number | Manufacturer | K&P Filter |
{$man_part_number} | {$manufacturer} | {$k_p_part} |