Code: Select all
// Build SQL Query
$query = "SELECT * FROM ida_business WHERE
industry LIKE '%$tindustry%' OR
region LIKE '%$tregion%' OR
range LIKE '%$trange%' OR
flow LIKE '%$flow%' OR
abs LIKE '%$abs%' OR
sale LIKE '%$tsale%' OR
price LIKE '%$tprice%'
ORDER BY region ASC";
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
This query isn't right but its the closest i could get it to being right. This is my first search script so any help will be great! If you need me to post more code just ask.
Thanks