Linking hotspots to a table

[rahulb1979]

I have an image (actually a map) and a table whose entries I have put in a mysql database.

The map has a number of hotspots on it and my goal is to retrieve rows from the table depending on the hotspot clicked.

I have workd on Online forms and know how to retrieve data through a form .
However this is a toughie for me . Since this is not a form I do not know how to send in information ( the hotspot corresponds to the primary key of the table) and thus query teh datbase through the php file. Can Anyone help?
Thanks.

[leatherback]

Hi,

This is how I solved a similar problem. It is using javascript for the submit, and an imagemap (in your case you would have to edit the code a bit: You can remove the Act=" + document.postcodezoeken.Act.value + "& bit. But the general ID shoul dbe clear, I suppose:

<SCRIPT LANGUAGE="javascript"> 
function processform(Prov) {
 newLocation = "results.php?Act=" + document.postcodezoeken.Act.value + "&Prov=" + Prov ;
 document.location.href = newLocation;
 return;
}
</script>


<form method="post" action="results.php" name="postcodezoeken" >

<IMG SRC="gif/nl.gif" USEMAP="#nl"  NAME="img1" BORDER=0>
<MAP NAME="nl">
  <AREA SHAPE=POLY COORDS="3,375,25,377,24,370,44,372,53,378,58,384,72,383,101,370,109,363,114,352,106,341,107,331,103,319,98,309,87,298,69,285,39,287,9,320,0,351,0,367,5,374" 
ALT="Zeeland"  onClick="processform('11'); return true" 
OnMouseOver="imgOn('img1'); return true" onMouseOut="imgOff()">


// blablablabla

</form>

[batman]

What you want to do is have all the hotspots on the image link to something like:
<a href="query.php?row=1">Row 1</a>
<a href="query.php?row=2">Row 2</a>
Then on the query.php page do something like this:

$id = $_GET['row'];
$sql = mysql_query("SELECT * FROM table");
$rows = mysql_fetch_row($sql);
$row = $rows['$id'];
echo "$row";

Something like that should work,
-Blake