<?php 

//------------------------------------------------------------------------------------------------------------------------------------- 
function &SearchForm() 
{//Display the search form 

    $search = "<form id=\"SearchForm\" title=\"Avaliability Search\" action=\"index.php?page=pages/search.php\" method=\"post\">"; 
    $search .= "<br /><fieldset class=\"field\"><legend class=\"leyenda\"> Search </legend> <br />"; 
     
    //Country Label 
    $search .= "<label for=\"country\" title=\"Select the country\" class=\"indent\">*Country: </label>"; 

    //Query to list countries 
    $query = "SELECT location, region FROM Villa ORDER BY location"; //Make the query to show all countries' names in alphabetical order. 
    $result = @mysql_query($query); //Run the query. 
    if ($result) //If it ran ok, display the records. 
    { 
        if (mysql_num_rows($result) > 0) 
        { 
    //Select box 
    $search .= "<select id=\"location\" name=\"location\" title=\"Select Country\" class=\"inputframe\">"; 
        while ($row = mysql_fetch_array($result)) 
    { 
    if (isset($_POST['location']) && (strcmp(stripslashes($row[0]), $_POST['location']) == 0)) 
    $search .=  "<option selected=\"selected\">"; 
    else 
    $search .= "<option>"; 
    $search .= stripslashes($row[0])."</option>"; 
    } 
    mysql_free_result($result); //Free up the resources. 
         
    $search .= "</select> </p>"; 
     
    //Region     
    $search .= "<label for=\"region\" title=\"Region\" class=\"indent\">*Region: </label>"; 
    $search .= "<select id=\"region\" name=\"region\" title=\"Region\" class=\"inputframe\">"; 
    $search .= "</select> </p>"; 

    //Button 
    $search .= "<div class=\"centro\">"; 
    $search .= "<input title=\"Search\" class=\"submit\" id=\"formsent\" name=\"formsent\" type=\"submit\" value=\"Search\">&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</button><br /><br /><br />"; 
    $search .= "</div></fieldset> </form>"; 
    } 
    else 
    $search .= "<p>There are currently no registered countries:</p>"; 
    } 
    else //If it did not run ok. 
    { 
        $search = "<p>The countries could not be displayed due to a system error. We apologise for any inconvenience.<p>"; 
        $search .= "<p>".mysql_error().": ".mysql_error()."</p>"; 
    } 
    return $search;             

} 
?>