如何将php变量嵌入到html href链接中？

Question

Requirement: Read rows from a mysql database, where one column contains an address and a city, make the resulting address into a link to google maps, by passing the address for the location only as described in the following link: is there a way to pass arguments to google map's get directions functionality? php code shippet $result = mysql_query($sql) or die(mysql_error()); while($row = mysql_fetch_array($result)) { echo''.$row['DAYTIME'].''.$row['MEETINGNAME'].' '.''.$row['ADDRESSCITY'].''.''.$row['BLDGNAME'].''; } ?> The above block of code sucefully creates a link to maps.google.com BUT I want to put $row['ADDRESSCITY'] between the "http://maps.google.com/?q= and the closing " I tried this:

'<a href="http://maps.google.com/?q='.$row['ADDRESSCITY'].'/a'">'

and no results are displayed, and no error message either. Thanks

Answer 1

Change the url to this.

echo'<tr><td>'.$row['DAYTIME'].'</td><td>'.$row['MEETINGNAME'].'</td><td>'.'<a href="http://maps.google.com/?q='.$row['ADDRESSCITY'].'">Google Maps</a>'.'</td><td>'.$row['BLDGNAME'].'</td></tr>';