title: php form populating from mysql data
body: <p>I have a page that shows information from my database. Each array has an edit link that has a unic id (.html?id=4).</p>
  
  <p>The problem:
  The form I created to query the database based on the id results in no information being displayed?</p>
  
  <p>Any idea what I need to do to accomplish this?</p>
  
  <pre><code>&lt;?php
      // Connect to the database
  require 'include/episodelist.db.php';
      // Ask the database for the information from the table based on .html?id=#
  $query="SELECT * FROM `season` WHERE `id` = $id";
      //The above query is the problem.
  $result = mysql_query("SELECT * FROM 'season'");
  mysql_close();
  ?&gt;
  &lt;form action="include/epslist.edit.php" method="POST"&gt;
  &lt;table&gt;
  &lt;tr&gt;
  &lt;td&gt;Season Number: &lt;/td&gt;&lt;td&gt;&lt;input type="text" name="season_sum" size="50" value="&lt;?php echo "$season_num";?&gt;"&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
  &lt;td&gt;Episode Number: &lt;/td&gt;&lt;td&gt;&lt;input type="text" name="eps_num" size="50" value="&lt;?php echo "$eps_num";?&gt;"&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
  &lt;td&gt;Temp Episode Number: &lt;/td&gt;&lt;td&gt;&lt;input type="text" name="temp_eps_num" size="50" value="&lt;?php echo "$temp_eps_num";?&gt;"&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
  &lt;td&gt;Title: &lt;/td&gt;&lt;td&gt;&lt;input type="text" name="title" size="50" value="&lt;?php echo "$title";?&gt;"&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
  &lt;td&gt;Description: &lt;/td&gt;&lt;td&gt;&lt;textarea type="text" name="descrip" cols="50" rows="7" value="&lt;?php echo "$descrip";?&gt;"&gt;&lt;/textarea&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
  &lt;td colspan="2"&gt;
  &lt;input type="Submit" value="Update"&gt;
  &lt;/td&gt;
  &lt;/tr&gt;
  &lt;/table&gt;&lt;/form&gt;
  </code></pre>