Databases and image maps

[run_GMoney]

Can you send a value to a database depending on a location that you click on an image map? For instance, I've got an image map split into 8 parts, can I send a value, let's say "1" to a database if the section labeled "1" is clicked? Hopefully this is clear. Thanks

[Pig]

sure, just put a query string in the link for that section of the image map.

Then you can have a test to see if the $var is set, and execute the query accordingly.

eg: if the link looks like href="page.php?var=3" then the sql statement could be

if ( isset($var) )
     {
     mysql_query("INSERT INTO table_name column_name='something' where id='$var'");
     }

Did that make sense?

[Pig]

eh.. my sql statement was off, but you get the idea...

[run_GMoney]

I think so. Let me double check something here. Let's keep it simple. Let's say I have an image split into two parts. Both would be linking to the same page, we'll call it page1.php So what you're saying is in part 1, add something like "page1.php?var=1" and in part 2, I would add "page1.php?var=2" Am I following this properly? If so, that's pretty slick. Never even considered that solution. Lemme know if I'm on the right track here. Another quick question. Instead of sending it to the database, could I store it in a session variable?

BTW - I wasn't as concerned about the SQL part.

*EDIT - Looks like I can pretty much handle the sessions part of it, assuming the value of var is stored in the PHP variable $var.

[Pig]

Yeah, you can just pass the $var in the query string. On the page that is called, the $var will be available just has if you had written $var = 1;

just treat your $var like you would any other.

[run_GMoney]

Outstanding, I appreciate your help with that.