{source}
<p>Get pampered with a variety of nail care services and enhancements from Forever Polished Nail Spa.</p>

<?php
// Establish database connection.
$db = JFactory::getDbo();
$query = $db->getQuery(true);

$query->select(array('*'));
$query->from('#__price_menu');
$query->order('
case when category = "Manicures" then 1
when category = "Pedicures" then 2
when category = "Nails" then 3
when category = "Additional Services" then 4
when category = "Add-Ons" then 5
when category = "Children" then 6
when category = "Waxing" then 7
when category = "Eyelash Extensions" then 8
else 9
end ASC
');
//$query->order('category DESC');

// Set the query and load the results.
$db->setQuery($query);
$result = $db->loadObjectList();

// Organize the items in an array.
$items = array();
foreach($result as $item) {
$items[$item->category][] = array(
"Title" => $item->title,
"Description" => $item->description,
"Manicure Duration" => $item->duration_manicure,
"Manicure" => $item->price_manicure,
"Pedicure Duration" => $item->duration_pedicure,
"Pedicure" => $item->price_pedicure,
"Combo" => $item->price_combo,
"Child" => $item->price_kids,
"Half" => $item->price_half,
"Full" => $item->price_full,
"Set" => $item->price_set,
"Fill" => $item->price_fill,
"Full Overlay" => $item->price_full_overlay
);
}

$headers = array();
// Get Table Headers.
foreach($items as $key => $categoryItems) {
foreach($categoryItems as $categoryItem) {
foreach($categoryItem as $columnName => $value) {
if($value != '' && !in_array($columnName, $headers[$key])) {
$headers[$key][] = $columnName;
}
}
}
}

// Iterate each one of the categories into tables.
foreach($items as $key => $categoryItems) {
echo '<div id="' . str_replace(" ", "-", $key) . '" class="menu-section">';
echo '<h2>' . $key . '</h2>';
echo '<table class="price-menu ' . strtolower($key) . '">';
echo '<tr class="header">';
$i = 0;
foreach($headers[$key] as $column) {
echo '<th class="column-' . $i . '">&nbsp;<span class="column-name"></span></th>';
$i++;
}
echo '</tr>';
foreach ($categoryItems as $categoryItem) {
echo '<tr>';
foreach ($categoryItem as $columnName => $value) {
if ($column != '' && in_array($columnName, $headers[$key])) {
echo '<td class="' . $columnName . '">' . $value . '</td>';
}
}
echo '</tr>';
}
echo '</table>';
echo '</div>';
}
echo '<div id="price-menu-nav" class="menu-navigation"><a class="price-nav-logo" href="#g-page-surround"><img src="/images/Forever-Polished-logo-wide-white.png" /></a>';
foreach ($items as $key => $categoryItems) {
echo '<a href="#' . str_replace(" ", "-", $key) . '">' . $key . '</a>';
}
echo '</div>';
?>
<script type="text/javascript">
document.getElementById('price-nav').appendChild(
document.getElementById('price-menu-nav')
);
</script>
{/source}

About Forever Polished

No matter what your style, we have the nail technicians to keep you Forever Polished. Keeping your hands and feet looking their best could not be easier. From the softness of your skin to the crisp lines of your nails and cuticles, you will feel like a new person and ready to take on the world.

Contact Us

Forever Polished Nail Studio
2720 34th St. N
St. Petersburg, FL 33713

(727) 623-0065

info@foreverpolishednails.com

Monday–Saturday 9:00 a.m. to 7:00 p.m.
Sunday 10:00 a.m. to 5:00 p.m.