[insert_php]

$servername = “localhost”;
$username = “blueridg_bridge”;
$password = “kr~COSJQ7DP5”;
$dbname = “blueridg_bridge”;

$priceType = “regular_price”;

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
if( mysqli_connect_errno() ){
echo “Database Error: “.mysqli_connect_errno();
}else{
$sql = “SELECT name, packaging, “.$priceType.” AS price, promoting, category FROM bridge_products ORDER BY category, name ASC”;

if($result = mysqli_query($conn, $sql)){
while($row = mysqli_fetch_assoc($result)){
if($category){
if($category != $row[‘category’]){
$category = $row[‘category’];
echo ‘

‘.ucfirst($category).’

‘;
}
}else{
$category = $row[‘category’];
echo ‘

‘.ucfirst($category).’

‘;
}
echo ‘

‘;
}
echo ‘

‘;
}
}

[/insert_php]