Вывод информации из бд в виде ссылок

<?php
 
if (!empty($_POST['city'])){echo $_POST['city'];}
$preparate=$_POST['preparate'];
    mysql_connect("localhost", "root", "") or die (mysql_error ());
    mysql_select_db("Apteka2") or die(mysql_error());
    $strSQL = "SELECT Preparat.Name,Forma.Frm,Manufacturer.Manf,Country.CountryName,Preparat.Reactant,Tovar.Dozirovka,Preparat.Recipe,min(Stock.Price) min_price,max(Stock.Price) max_price,count(Apteki.id) apt
    FROM  ((Stock INNER JOIN (Preparat INNER JOIN (Manufacturer INNER JOIN (Forma INNER JOIN (Country INNER JOIN Tovar ON Country.id = Tovar.idCountry) ON Forma.id = Tovar.idForma) ON Manufacturer.id = Tovar.idManufacturer) ON Preparat.id = Tovar.idPreparat) ON Stock.idTovar = Tovar.id) INNER JOIN Apteki ON Stock.idApteki = Apteki.id) INNER JOIN City ON Apteki.idCity = City.id WHERE Name='".$preparate."' Group by Preparat.Name,Forma.Frm,Manufacturer.Manf,Country.CountryName,Preparat.Reactant,Preparat.Recipe,Tovar.Dozirovka";
    $rs = mysql_query($strSQL);
    if($rs === FALSE) {
    die(mysql_error()); // ошибки
}
    unset($_POST['preparate']);
    $k=1;
    while($row = mysql_fetch_array($rs)) {
    if($k%2==0) $color="#FFFFFF";else $color="#F1F1F1"; 
$k++;
echo '<tr class="tr_main_result_search">';
echo '<td width="16px" align="center" BGCOLOR="#189210"}><input type="checkbox" name="_All" /></td>';
echo '<td class="td_main_result_search_click" BGCOLOR="'.$color.'"><a href="#">'.$row['Name'].'</a></td>';
echo '<td class="td_main_result_search_click" BGCOLOR="'.$color.'"><a href="#">'.$row['Frm'].' '.$row['Dozirovka'].'</a></td>';
echo '<td class="td_main_result_search_click" BGCOLOR="'.$color.'"><a href="#">'.$row['Manf'].'</a></td>';
echo '<td class="td_main_result_search_click" BGCOLOR="'.$color.'"><a href="#">'.$row['CountryName'].'</a></td>';
echo '<td class="td_main_result_search_click" BGCOLOR="'.$color.'"><a href="#">'.$row['Reactant'].'</a></td>';
echo '<td class="td_main_result_search" BGCOLOR="'.$color.'">'.$row['Recipe'].'</td>';
echo '<td class="td_main_result_search" BGCOLOR="'.$color.'">pic</td>';
echo '<td class="td_main_result_search" BGCOLOR="'.$color.'">'.$row['min_price'].'</td>';
echo '<td class="td_main_result_search" BGCOLOR="'.$color.'">'.$row['max_price'].'</td>';
echo '<td class="td_main_result_search" BGCOLOR="'.$color.'"><a href="#">'.$row['apt'].'</a></td>';
echo '<td class="td_main_result_search" BGCOLOR="'.$color.'">'.$k.'</td>';
echo '</tr>';
                            }
    mysql_close();
?>

foreach($names as $name=>&$value) {
 if(isset($_GET[$name]) $value = $mysqli->real_escape_string($_GET[$name]);
}