title: Fetching rows from database and making them links to other pages
body: <p>I think the question title is not so accurate but here are the details of the problem i am facing.
  I have Movies Database in Oracle10g
  I have included an option for user to search for movies in the database by title.
  I am using this piece of code to Display the rows Retured...</p>
  
  <pre><code>&lt;h1&gt;Search Results&lt;/h1&gt;
  &lt;table border = "1px"&gt;
  &lt;thead&gt;
  &lt;tr&gt;
      &lt;th&gt;ID&lt;/th&gt;
      &lt;th&gt;RATING&lt;/th&gt;
      &lt;th&gt;Title&lt;/th&gt;
      &lt;th&gt;Description&lt;/th&gt;
      &lt;th&gt;Category&lt;/th&gt;
      &lt;td&gt;Duration&lt;/td&gt;
      &lt;td&gt;Actor&lt;/td&gt;
  &lt;/tr&gt;
  &lt;/thead&gt;
  &lt;tbody&gt;
  &lt;?php
  $search = $_POST['search'];
  $search = sanitize($search);
  $search = '%'.$search.'%';
  $conn = oci_connect("asim","asim","localhost/xe");
  $stid = oci_parse($conn,"SELECT 
                  film.film_id AS FID,
                  film.title AS title,
                  film.description AS description,
                  category.name AS category,
                  film.duration AS length,
                  film.rating AS rating,
                  CONCAT ( actor.first_name ,CONCAT(' ', actor.last_name)) AS actors
                  FROM category 
                  LEFT JOIN film_category ON category.category_id = film_category.category_id
                      LEFT JOIN film ON film_category.film_id = film.film_id
                       JOIN film_actor ON film.film_id = film_actor.film_id
                       JOIN actor ON film_actor.actor_id = actor.actor_id
                  WHERE title LIKE '".$search."'");
      oci_execute($stid);
      while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {
          print "&lt;tr&gt;\n";
      foreach ($row as $item) {
          print "    &lt;td&gt;" . ($item !== null ? htmlentities($item, ENT_QUOTES) : "&amp;nbsp;") . "&lt;/td&gt;\n";
      }
             print "&lt;/tr&gt;\n";
      }
  ?&gt;
  &lt;/tbody&gt;
  &lt;/table&gt;
  </code></pre>
  
  <p>I am getting the results Displayed in a table form!
  now what i want is that make the title or the film_id of every film fetched to be  a link.
  and when clicked it should navigate to a specific page of that Movie.
  That page could be like <strong>index.php?id=1337</strong>
  and on the index page  $_GET['userid'] could be used to fetch info about that movie
  The main problem is making the film_id or title or the whole row a link
  I tried using the  tag but wasnt successful.
  I am a newbie to PHP and oracle.
  Any kind of help would be very appreciated.</p>