Here is the code I am using that is not working as desired:
Code: Select all
if($_POST['linkgen'] == true) {
$result = mysql_query("SELECT dest_addr
FROM destinations
WHERE selected = '1'");
$counter = mysql_num_rows($result);
echo "<a href=\"";
echo "http://maps.google.com/maps?f=d&source=s_d";
while ($row = mysql_fetch_array($result)) {
switch($counter) {
case 1:
echo "http://maps.google.com/maps?f=d&source=s_d";
echo "&saddr=";
echo $row[0];
break;
case 2:
echo "http://maps.google.com/maps?f=d&source=s_d";
echo "&saddr=";
echo $row[0];
echo "&daddr=";
echo $row[1];
break;
case 3:
echo "http://maps.google.com/maps?f=d&source=s_d";
echo "&saddr=";
echo $row[0];
echo "&daddr=";
echo $row[1];
echo "&mrad=";
echo $row[2];
break;
case "4":
echo "http://maps.google.com/maps?f=d&source=s_d";
echo "&saddr=";
echo $row[0];
echo "&daddr=";
echo $row[1];
echo "&mrad=";
echo $row[2];
echo "&mrad=";
echo $row[3];
break;
case "5":
echo "http://maps.google.com/maps?f=d&source=s_d";
echo "&saddr=";
echo $row[0];
echo "&daddr=";
echo $row[1];
echo "&mrad=";
echo $row[2];
echo "&mrad=";
echo $row[3];
echo "&mrad=";
echo $row[4];
break;
case "6":
echo "http://maps.google.com/maps?f=d&source=s_d";
echo "&saddr=";
echo $row[0];
echo "&daddr=";
echo $row[1];
echo "&mrad=";
echo $row[2];
echo "&mrad=";
echo $row[3];
echo "&mrad=";
echo $row[4];
echo "&mrad=";
echo $row[5];
break;
case "7":
echo "http://maps.google.com/maps?f=d&source=s_d";
echo "&saddr=";
echo $row[0];
echo "&daddr=";
echo $row[1];
echo "&mrad=";
echo $row[2];
echo "&mrad=";
echo $row[3];
echo "&mrad=";
echo $row[4];
echo "&mrad=";
echo $row[5];
echo "&mrad=";
echo $row[6];
break;
case "8":
echo "http://maps.google.com/maps?f=d&source=s_d";
echo "&saddr=";
echo $row[0];
echo "&daddr=";
echo $row[1];
echo "&mrad=";
echo $row[2];
echo "&mrad=";
echo $row[3];
echo "&mrad=";
echo $row[4];
echo "&mrad=";
echo $row[5];
echo "&mrad=";
echo $row[6];
echo "&mrad=";
echo $row[7];
break;
case "9":
echo "http://maps.google.com/maps?f=d&source=s_d";
echo "&saddr=";
echo $row[0];
echo "&daddr=";
echo $row[1];
echo "&mrad=";
echo $row[2];
echo "&mrad=";
echo $row[3];
echo "&mrad=";
echo $row[4];
echo "&mrad=";
echo $row[5];
echo "&mrad=";
echo $row[6];
echo "&mrad=";
echo $row[7];
echo "&mrad=";
echo $row[8];
break;
case "10":
echo "http://maps.google.com/maps?f=d&source=s_d";
echo "&saddr=";
echo $row[0];
echo "&daddr=";
echo $row[1];
echo "&mrad=";
echo $row[2];
echo "&mrad=";
echo $row[3];
echo "&mrad=";
echo $row[4];
echo "&mrad=";
echo $row[5];
echo "&mrad=";
echo $row[6];
echo "&mrad=";
echo $row[7];
echo "&mrad=";
echo $row[8];
echo "&mrad=";
echo $row[9];
break;
case "11":
echo "http://maps.google.com/maps?f=d&source=s_d";
echo "&saddr=";
echo $row[0];
echo "&daddr=";
echo $row[1];
echo "&mrad=";
echo $row[2];
echo "&mrad=";
echo $row[3];
echo "&mrad=";
echo $row[4];
echo "&mrad=";
echo $row[5];
echo "&mrad=";
echo $row[6];
echo "&mrad=";
echo $row[7];
echo "&mrad=";
echo $row[8];
echo "&mrad=";
echo $row[9];
echo "&mrad=";
echo $row[10];
break;
case "12":
echo "http://maps.google.com/maps?f=d&source=s_d";
echo "&saddr=";
echo $row[0];
echo "&daddr=";
echo $row[1];
echo "&mrad=";
echo $row[2];
echo "&mrad=";
echo $row[3];
echo "&mrad=";
echo $row[4];
echo "&mrad=";
echo $row[5];
echo "&mrad=";
echo $row[6];
echo "&mrad=";
echo $row[7];
echo "&mrad=";
echo $row[8];
echo "&mrad=";
echo $row[9];
echo "&mrad=";
echo $row[10];
echo "&mrad=";
echo $row[11];
break;
case "13":
echo "http://maps.google.com/maps?f=d&source=s_d";
echo "&saddr=";
echo $row[0];
echo "&daddr=";
echo $row[1];
echo "&mrad=";
echo $row[2];
echo "&mrad=";
echo $row[3];
echo "&mrad=";
echo $row[4];
echo "&mrad=";
echo $row[5];
echo "&mrad=";
echo $row[6];
echo "&mrad=";
echo $row[7];
echo "&mrad=";
echo $row[8];
echo "&mrad=";
echo $row[9];
echo "&mrad=";
echo $row[10];
echo "&mrad=";
echo $row[11];
echo "&mrad=";
echo $row[12];
break;
case "14":
echo "http://maps.google.com/maps?f=d&source=s_d";
echo "&saddr=";
echo $row[0];
echo "&daddr=";
echo $row[1];
echo "&mrad=";
echo $row[2];
echo "&mrad=";
echo $row[3];
echo "&mrad=";
echo $row[4];
echo "&mrad=";
echo $row[5];
echo "&mrad=";
echo $row[6];
echo "&mrad=";
echo $row[7];
echo "&mrad=";
echo $row[8];
echo "&mrad=";
echo $row[9];
echo "&mrad=";
echo $row[10];
echo "&mrad=";
echo $row[11];
echo "&mrad=";
echo $row[12];
echo "&mrad=";
echo $row[13];
break;
default:
break;
}
}
echo "\">" . "Directions" . "</a>";
}