php mysql hyperlink help

muttboi10

I want to have hyperlinks using dynamic data pull from the database but no matter what I try I can only get the link to show up and it does not work. It is also listing the links side by side instead of in rows. Any help will be greatly appreciated.

<?php

ini_set ("display_startup_errors", "1");
ini_set ("display_errors", "1");

$dbh=mysql_connect ("localhost", "skreemn_carl", "") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("skreemn_2hm");

$Result = mysql_query("SELECT * FROM Regions",$dbh) or die(mysql_error());

mysql_select_db ("skreemn_2hm");

while($Row = mysql_fetch_array($Result))
{
$Reghotels = $Row['Reghotels'];
$Reg_id = $Row['Reg_id'];
$Region = $Row['Region'];

print $movie_details .=<<<EOD
<tr>

<td><a href='http://www.skreem.net/2hm/regionlist1.php?Reg_id=$Reg_id'Reghotels='This is a test'>$Region</td>

</td>

EOD;

}

mysql_close ($dbh);
?>

returns this
Antigua Antigua Mexico

as links then when the link is clicked it returns the same thing.

yelvington

Your table structure is bad; you are creating TRs without closing them. If you want to generate valid URLs, you'll need to use ampersands between name=value pairs, and if the value contains spaces or other illegal characters, you will need to urlencode the value.

muttboi10

with some help I got the links fixed now i just need to make it where they actually pull the info from the database

<html>
<body>
<table>
<?php
$dbh=mysql_connect ("localhost", "skreemn_carl", "") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("skreemn_2hm");
$Result = mysql_query("SELECT * FROM Regions",$dbh) or die(mysql_error());

while($Row = mysql_fetch_array($Result))
{
$Hotel_id = $Row['Hotel_id'];
$Reg_id = $Row['Reg_id'];
$Region = $Row['Region'];
echo "<tr><td>";
echo "<a href='http://www.skreem.net/2hm/regionlist1.php?HOtel_id=". $Hotel_id. "'>". $Region. "</a></td></tr>";
}

?>
</table>
</body>
</html>