I'm stuck on the problem that I cannot resolve.
On main page I have seach box form with few drop down in which I select data and also two text boxes in which I enter data. Method in form is GET.
I manage to colect selected data (type, category, location, size, price) on search page “search.php”, and all that I choose from drop down menu I save in variable ($type, $category, $location, $size, $price), I see all selected data in my search.php page with echo command.
Now, I want to make search in DB in table wp_posts with this data like criteria, something like: if I in eny Page or Post find value that match choosen value from <form> show this data in some form of table. I start with:
$qurey = “SELECT * FORM wp_posts WHERE ?????”
$result = mysql_query($query);
echo ("Error #1!\n");
$number = mysql_num_rows($result);
if (!$number) echo ("Error #2!\n");
$i = 0;
echo “Make table….”;
while ($i < $number)………
Any suggestion is more then welcome.