tengo poco conocimiento de PHP puesto que estoy iniciando, les agradecería la ayuda...
Código HTML:
<select id='Country' name='Country' class='sort_button'><option value=''>Sort by Country</option><option id='selectCR'value='6'>Costa Rica</option><option id='selectMX' value='12'>Mexico</option><option id='selectSL' value='26'>El Salvador</option></select>
Código PHP:
$querySrt = "SELECT companies.id as EmpresaID,companies.country_id as PaisID, countries.name as Pais, companies.name as Empresa FROM companies INNER JOIN countries ON countries.id=companies.country_id ";
if ( !empty($_POST["Country"]) ) {
$querySrt .=" WHERE companies.country_id=$VALOR_DEL_SELECT LIMIT $start, $per_page";
}