Using images with recordsets

[Guest]

Hello. I have a quick question. With images in Dreamweaver, you can link them and set hyperlinks, etc. Is there a way that if you click an image, it can pull up information in a database?

eg. I have a US map where each state has the ALT with state names when you roll over it. What I want it to be able to, (if its possible of course) is when a person clicks on the certain state, they are taken to the page with the information filtered by a recordset with each states data. First, is this possible? Second, how would you go about this if it is?

Do you hotlink the area to each state page and create the recordset to display the data on that certain page? If anyone would kindly help me out with some tips I would appreciate it!

Thanks,
Ashley

[MikeL7]

You could use hotspots to create a link and then assign a parameter to the link to filter the recordset on the detail page, so your links would be 'statedetail.php?state=50' which might be Hawaii. Make a recordset that is filtered by a url parameter named state in this example, if you have the states in a db with a number id. you could also pass the name of the state and filter by that.