How can I develop a "search product by characteristics in PHP"

[JORVA]

Hello, something can help me?
I need to develop a product searcher, with option to choose ex.
Color: - Red - ble - white
Dimension: - large - small - medium
material: - cotton - nylon
etc.
Submit.

Then: product 1 or 2 or 3

In PHP with sql

Thank you.

[echelon7]

Hmm. From what I understand in your posting.

You first of need to have your tables to have the fields for options. If you are coding from

You need to make sure you strip out and potential SQL injection attacks in these variables and verify that is what you are expecting. Try using mysql_escape_real_string()

$searchColor = POST/GET var
$searchDimension = POST/GET var
$searchMaterial = POST/GET var


$sql = "SELECT * FROM ProductsTable WHERE color = `$searchColor`, dimension = `$searchDimension`, material = `$searchMaterial`... etc ORDER BY $searchColor";

query($sql)


If you are trying to do this as a shopping cart. Try looking into ones that are already made. One such is CubeCart with product options and search.

Brian