I need the year needs to be passed as a variable in the link so it can be grabbed via a get statement
<p>My html page.
I have this line.</p>

<pre><code>&lt;a href="Player_Roster.php?inputyr=2011"&gt;2011&lt;/a&gt;&lt;br /&gt;
</code></pre>

<p>My php page.
I have this line of code.</p>

<pre><code>&lt;?php
$inputyr = $_GET[inputyr];
$query = "SELECT * FROM players
WHERE playeryear = $inputyr;
ORDER BY number";
$players = mysql_query($query);
?&gt;
</code></pre>

<p>I want my php page to do a query using the year 2011.</p>

<p>After I click on the link it opens the page.  It does show...
but the players don't fill in the table.  The query does work if I manually type in the 2011.</p>
