Linking image map to my database

parn27

Please help! I have a image map of North America and im trying to link it to a database. When you click the province or state it should bring up that province or state information.

Heres my code for the image map.

Heres the code where my hot spot should go.

<?
include('mapconnection.inc');
$id=$_POST['id'];

$sql = "SELECT tblCanada.locationID, tblCanada.Province, tblCanada.Description FROM tblCanada WHERE tblCanada.locationID=$id ORDER BY Province";

$rs = $conn->Execute($sql);
?>

Thank you

bastien

href links use $GET['id'] not $POST['id']

parn27

Still not working. Hmmm now I'm getting these 2 errors Notice: Array to string conversion and Fatal error: Call to undefined function: array().

bastien

show all code

parn27

Viewlocation.php Page

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>North American Map</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

viewsinglelocation.php Page

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<?
include('mapconnection.inc');
$id= $_GET('id');
//$id=2

$sql = "SELECT tblCanada.locationID, tblCanada.Province, tblCanada.Description FROM tblCanada WHERE tblCanada.locationID=$id ORDER BY Province";

$rs = $conn->Execute($sql);
?>

<html>
<head>
<title>ViewRecords</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/JavaScript">

</script>
</head>
<body>

<table>
<tr align="left">
<th width="37">ID</th>
<th width="150">Province</th>
<th width="500">Description</th>

</tr>
<? // while (!$rs->EOF): ?>
<tr>
<td><?= $rs->Fields['locationID']->Value ?></td>
<td><?= $rs->Fields['Province']->Value ?></td>
<td><?= $rs->Fields['Description']->Value ?></td>
</tr>
<? // $rs->MoveNext() ?>
<? //endwhile ?>
</table>
<?

$rs->Close();
$conn->Close();

?>
</body>
</html>

bastien

its not

$id= $_GET('id');

its

$id= $_GET['id'];

square brackets

parn27

Thank you so much. Bastien you rock. Something so simple, but I researched this for hours on the web. Too funny.

Thanks again.