Href parameters

PHP
1

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:

products.html:

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

database.php

<html>
<title>Database Stuff</title>


<?php
	$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;
?>

</html>
2

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

3

Cool, thank you very much.