- ‘;
$a=1;
while($category = mysql_fetch_array($resultCategory)) {
$category_found2 = $category[‘Category’];
$category_found = str_replace(‘ ‘, ”, $category_found2);
echo ‘
‘;
$a++;
}
echo ‘
The Aviation Yellow Pages has a comprehensive list of contacts for all your aviation requirements! We aim to have all the correct contact details and links to as many websites as possible to ensure you get as much detail from our information as possible. However, if you know of any information that may be wrong or outdated, please contact us with the correct details. Thank you!
Submit
[insert_php]
// MySQL server
define(‘DB_HOST’, ‘localhost’);
// Database name
define(‘DB_NAME’, ‘aviation_db’);
// MySQL username
define(‘DB_USER’, ‘aviation_db’);
// MySQL password
define(‘DB_PASS’, ‘!@aviationD#$PPC’);
$DB = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die (“Couldn’t connect”);
mysql_select_db(DB_NAME, $DB) or die (“Couldn’t select database”);
$result = mysql_query(“SELECT DISTINCT (Country) FROM aviation_services”);
// COUNTRY
$num_row_country = mysql_num_rows($result);
$x = 1;
echo ‘
echo ‘ tab’ . $x . ‘=”‘ . $country_found . ‘” tab’. $x .’_icon=”icon-globe”‘;
// MySQL server
define(‘DB_HOST’, ‘localhost’);
// Database name
define(‘DB_NAME’, ‘aviation_db’);
// MySQL username
define(‘DB_USER’, ‘aviation_db’);
// MySQL password
define(‘DB_PASS’, ‘!@aviationD#$PPC’);
$DB = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die (“Couldn’t connect”);
mysql_select_db(DB_NAME, $DB) or die (“Couldn’t select database”);
$resultCategory = mysql_query(“SELECT DISTINCT (Category) FROM `aviation_services` WHERE `Country` = ‘$country_found2′”);
$x++;
}
echo ‘]’;
//////////////////////////////////////////////////////////////////////////////////////////////////////////
// Find all the category for the menu only ( Distinct)
// MySQL server
define(‘DB_HOST’, ‘localhost’);
// Database name
define(‘DB_NAME’, ‘aviation_db’);
// MySQL username
define(‘DB_USER’, ‘aviation_db’);
// MySQL password
define(‘DB_PASS’, ‘!@aviationD#$PPC’);
$DB = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die (“Couldn’t connect”);
mysql_select_db(DB_NAME, $DB) or die (“Couldn’t select database”);
$result = mysql_query(“SELECT DISTINCT (Country) FROM aviation_services”);
while($country = mysql_fetch_array($result)) {
$country_found = str_replace(‘ ‘, ”, $country[‘Country’]);
$country_found2 = $country[‘Country’];
$resultCategory = mysql_query(“SELECT DISTINCT (Category) FROM `aviation_services` WHERE `Country` = ‘$country_found2′”);
//////////////////////////////////////////////////////////////////////////////////////////////////////////
// CATEGORY
$num_row = mysql_num_rows($resultCategory);
echo ‘
$a=1;
while($category = mysql_fetch_array($resultCategory)) {
$category_found2 = $category[‘Category’];
$category_found = str_replace(‘ ‘, ”, $category_found2);
echo ‘
‘;
$a++;
}
echo ‘
‘;
//////////////////////////////////////////////////////////////////////////////////////////////////////////
// Find all the category for details alone
// MySQL server
define(‘DB_HOST’, ‘localhost’);
// Database name
define(‘DB_NAME’, ‘aviation_db’);
// MySQL username
define(‘DB_USER’, ‘aviation_db’);
// MySQL password
define(‘DB_PASS’, ‘!@aviationD#$PPC’);
$DB = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die (“Couldn’t connect”);
mysql_select_db(DB_NAME, $DB) or die (“Couldn’t select database”);
$resultCategory_new = mysql_query(“SELECT DISTINCT (Category) FROM `aviation_services` WHERE `Country` = ‘$country_found2′”);
while($categoryTest = mysql_fetch_array($resultCategory_new)) {
$category_found_new2 = $categoryTest[‘Category’];
$category_found_new = str_replace(‘ ‘, ”, $category_found_new2);
echo ‘
‘;
}
echo ‘