WordPress.org

Ready to get started?Download WordPress

Forums

Search form box PROBLEM ******* (1 post)

  1. dinoni
    Member
    Posted 2 years ago #

    Hello
    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);
    if (!$result){
    echo ("Error #1!\n");
    }
    while ($row=mysql_fetch_row($result))
    {
    $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.
    Regards

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags