MX Query Builder Forum :: Multiple condition querey
This thread was displayed: 0 times
Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.
For more information about the affected products visit: www.interaktonline.com/Support/
ryan Pratt
11-18-2008 03:45:12 GMT +2
|
Ok i need to do a query on a db that allows me to pass multiple URL variables in the form of strings and have the db return all records that match the conditions.
?z
Bellow is the code im trying? Help
SELECT li_classification.classification_order, tool.tool_order, li_classification.classification_name, tool.tool_name, tool.tool_color, li_classification.classification_color, tool.tool_id, tool.tool_zone, tool.tool_cost, tool.tool_maintenance, tool.tool_slope, tool.tool_soil, tool.tool_climate, li_classification.classification_id
FROM (tool
LEFT JOIN li_classification ON li_classification.classification_id=tool.tool_LI_classification_id)
WHERE tool.tool_zone LIKE '%".$_GET["zone"]."%'
AND tool.tool_cost LIKE '%".$_GET["cost"]."%'
ORDER BY li_classification.classification_order ASC, tool.tool_order ASC
|
|
|
