using a $_GET id to filter a mysql_fetch_array in PHP
<p>So I have a query that I am returning all of the items into a mysql_fetch_array. Now, I know I could write another query and just select the items I need into a seperate query but, is there a way to just filter from the larger query what I want dependent on $_GET? </p>

<p>So, in english the user comes from a hyperlink that has ?id=1 and I peform a while that gets the all the values but, only display the $_GET['id'] items in a list </p>

<pre><code>&lt;?php //give ma all values but only echo out list of the $_GET['id'] in the url
  while ($row = mysql_fetch_array($result) {
    $id = $rowvideo["id"];
    $title = $rowvideo["title"];
    $length = $rowvideo["length"];
}
echo("&lt;li&gt;&lt;a href='#'&gt;". $title." " .$length. "&lt;/a&gt;&lt;/li&gt;");
?&gt;
</code></pre>

<p>Hope this makes sense. Thank you all.</p>
