Href parameters

Hi, I am trying to pass arguments from one page to another in order to query a database. Here is what I have so far (this is an example I made up, not the final site design).

My question now is how do I get the new page (database.php) to recognize the parameters in the href statements in the products.html page? Here is the code:


    <a href="database.php?code=gun&color=silver">Silver Gun</a>
    <a href="database.php?code=holster&color=tan">Tan Holster</a>


<title>Database Stuff</title>

	$productCode = code;
        $productColor = color;
        mysql_connect("server", "database", "password") or die(mysql_error());
	echo "Connected to MySQL<br/>";
	mysql_select_db("database") or die(mysql_error());
	echo "Connected to Database";
        echo "</br>".$productCode;
        echo "</br>".$productColor;


they will be in the $_GET array, i.e. $_GET[‘code’]

Cool, thank you very much.