<?php

    $con = mysqli_connect('localhost', 'mayabeac_wine', '3]eGo-r(Scru',"mayabeac_WineList");
        if (mysqli_connect_errno()) {
            echo"
                Failed to connect to the MySQL DB:".mysqli_connect_error();
            }
           else{


}




$sql="SELECT DISTINCT WineCountry FROM Wines2 WHERE QtyInStock <> -1 AND OutOfStock = 0 AND Archived=0 AND LeaveOffMenu=0 AND WineType <> 'Beer' ORDER BY WineCountry"; 
$records = mysqli_query($con, $sql); 




echo "<table style='text-align: center; font-size: 1.5em;'>";

    
//echo "<colgroup>";
 //      echo "<col span='1' style='width: 20em;'>";
  //      echo "<col span='1' style='width: 2em;'>";
   //    echo "<col span='1' style='width: 20em;'>";
    //  echo "</colgroup>";


while($wine=mysqli_fetch_assoc($records)){
if(!empty($wine['WineCountry'])){

    	echo "<tr><td style='font-size=1.5em;  text-align: left;'><a href='http://bistrowinelist.com/byCountry/?Listing=".$wine['WineCountry']."'>".$wine['WineCountry']."</a></td><td></td>";  	
    }

  	


}


echo "</table>";