query($strQuery_cat) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}");
// If the query returns a valid response, get the cat details
if ($result_cat) {
while($row_cat = mysqli_fetch_array($result_cat)) {
$cat_id = $row_cat['id'];
$cat_name = $row_cat['category_name'];
$cat_slug = $row_cat['slug'];
//get all honorees in this category
$strQuery_hon = "SELECT * FROM default_power100_honorees WHERE year=2017 and cat_id=".$cat_id." order by name asc";
// Execute the query, or else return the error message.
$result_hon = $dbhandle->query($strQuery_hon) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}");
echo '
';
echo '
'.$cat_name.'';
switch ($cat_slug){
case "community-crusaders":
echo '';
break;
case "entertainers":
echo 'Presented by CADILLAC';
break;
}
echo '
';
echo '
';
while($row_hon = mysqli_fetch_array($result_hon)) {
$hon_slug = $row_hon['slug'];
$hon_name = $row_hon['name'];
echo '
'.$hon_name.'';
}
echo '
';
echo '
';
}
}
?>
query($strQuery_cat) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}");
// If the query returns a valid response, get the cat details
if ($result_cat) {
while($row_cat = mysqli_fetch_array($result_cat)) {
$cat_id = $row_cat['id'];
$cat_name = $row_cat['category_name'];
$cat_slug = $row_cat['slug'];
//get all honorees in this category
$strQuery_hon = "SELECT * FROM default_power100_honorees WHERE year=2017 and cat_id=".$cat_id." order by name asc";
// Execute the query, or else return the error message.
$result_hon = $dbhandle->query($strQuery_hon) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}");
echo '
';
echo '
';
echo '
';
while($row_hon = mysqli_fetch_array($result_hon)) {
$hon_slug = $row_hon['slug'];
$hon_name = $row_hon['name'];
echo '
'.$hon_name.'';
}
echo '
';
echo '
';
}
}
?>
query($strQuery_cat) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}");
// If the query returns a valid response, get the cat details
if ($result_cat) {
while($row_cat = mysqli_fetch_array($result_cat)) {
$cat_id = $row_cat['id'];
$cat_name = $row_cat['category_name'];
$cat_slug = $row_cat['slug'];
//get all honorees in this category
$strQuery_hon = "SELECT * FROM default_power100_honorees WHERE year=2017 and cat_id=".$cat_id." order by name asc";
// Execute the query, or else return the error message.
$result_hon = $dbhandle->query($strQuery_hon) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}");
echo '
';
echo '
'.$cat_name.'';
switch ($cat_slug){
case "entrepreneurs":
echo '';
break;
}
echo '
';
echo '
';
while($row_hon = mysqli_fetch_array($result_hon)) {
$hon_slug = $row_hon['slug'];
$hon_name = $row_hon['name'];
echo '
'.$hon_name.'';
}
echo '
';
echo '
';
}
}
?>
query($strQuery_cat) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}");
// If the query returns a valid response, get the cat details
if ($result_cat) {
while($row_cat = mysqli_fetch_array($result_cat)) {
$cat_id = $row_cat['id'];
$cat_name = $row_cat['category_name'];
$cat_slug = $row_cat['slug'];
//get all honorees in this category
$strQuery_hon = "SELECT * FROM default_power100_honorees WHERE year=2017 and cat_id=".$cat_id." order by name asc";
// Execute the query, or else return the error message.
$result_hon = $dbhandle->query($strQuery_hon) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}");
echo '
';
echo '
'.$cat_name.'';
switch ($cat_slug){
case "trendsetters":
echo '';
break;
}
echo '
';
echo '
';
while($row_hon = mysqli_fetch_array($result_hon)) {
$hon_slug = $row_hon['slug'];
$hon_name = $row_hon['name'];
echo '
'.$hon_name.'';
}
echo '
';
echo '
';
}
}
?>
query($strQuery_cat) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}");
// If the query returns a valid response, get the cat details
if ($result_cat) {
while($row_cat = mysqli_fetch_array($result_cat)) {
$cat_id = $row_cat['id'];
$cat_name = $row_cat['category_name'];
$cat_slug = $row_cat['slug'];
//get all honorees in this category
$strQuery_hon = "SELECT * FROM default_power100_honorees WHERE year=2017 and cat_id=".$cat_id." order by name asc";
// Execute the query, or else return the error message.
$result_hon = $dbhandle->query($strQuery_hon) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}");
echo '
';
echo '
'.$cat_name.'';
switch ($cat_slug){
case "women-up":
echo '';
break;
}
echo '
';
echo '
';
while($row_hon = mysqli_fetch_array($result_hon)) {
$hon_slug = $row_hon['slug'];
$hon_name = $row_hon['name'];
echo '
'.$hon_name.'';
}
echo '
';
echo '
';
}
}
?>
query($strQuery_cat) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}");
// If the query returns a valid response, get the cat details
if ($result_cat) {
while($row_cat = mysqli_fetch_array($result_cat)) {
$cat_id = $row_cat['id'];
$cat_name = $row_cat['category_name'];
$cat_slug = $row_cat['slug'];
//get all honorees in this category
$strQuery_hon = "SELECT * FROM default_power100_honorees WHERE year=2017 and cat_id=".$cat_id." order by name asc";
// Execute the query, or else return the error message.
$result_hon = $dbhandle->query($strQuery_hon) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}");
echo '
';
echo '
'.$cat_name.'';
if ($cat_slug=="women-up"){ echo '';}
echo '
';
echo '
';
while($row_hon = mysqli_fetch_array($result_hon)) {
$hon_slug = $row_hon['slug'];
$hon_name = $row_hon['name'];
echo '
'.$hon_name.'';
}
echo '
';
echo '
';
}
}
?>