title: Putting query data from multiple table in a html table
body: <p>I have a database with 5 tables, 1 of them is filled with ID's. I want to link them to the other tables (the ID's are already there) so it will show the names. for example:  </p>
  
  <p>ask Genre: Action</p>
  
  <p>It will retrieve the Film names, Director names, Genre name, Rating and 3D option.</p>
  
  <p>It will show all filmnames regarding the genre as well as the ID's of the columns of those tables. </p>
  
  <p>I then tried to make query (see below) that will be able to spit out the other names, but when I try to put them in a html table it will show up with a problem saying:</p>
  
  <blockquote>
    <p>Notice: Undefined index: F.Name in ../public_html/selection_lookup.php on line 53</p>
  </blockquote>
  
  <p>The same for the other names in the table.</p>
  
  <p>The code I'm using is the following:</p>
  
  <pre><code>&lt;?php
      include ('login.php');
      $dcxn = mysql_connect($db_hostname, $db_username, $db_password) or die ("couldn't connect to server");
  
      mysql_select_db($db_database) or die("unable to select database:" . mysql_error());
  
      $selection = $_POST["GenreSel"];
  
      $query= "
                  SELECT F.Name, D.Name, G.Genre, R.Rating, T.ThreeDeeOption
                  FROM Film F, Director D, Genre G, Rating R, ThreeDee T
                  WHERE F.GenreID=$selection 
                  AND F.DirID = D.DirID
                  AND F.GenreID = G.GenreID
                  AND F.RatingID = R.RateID
                  AND F.ThreeDeeID = T.ThreeDeeID
      ";
  
  
      $result = mysql_query($query);
  
      if (!$result) die ("Database access failed:" . mysql_error());
  
      echo '&lt;pre&gt;';
      print_r($result);
      echo'&lt;/pre&gt;';
  
  ?&gt;
  
  
  &lt;table border="ridge"&gt;
      &lt;tr class="header"&gt;
          &lt;td&gt;Name&lt;/td&gt;
          &lt;td&gt;Director&lt;/td&gt;
          &lt;td&gt;Genre&lt;/td&gt;
          &lt;td&gt;Rating&lt;/td&gt;
          &lt;td&gt;available in 3D?&lt;/td&gt;
      &lt;/tr&gt;
      &lt;?php
         while ($row = mysql_fetch_array($result)) {
             echo "&lt;tr&gt;";
             echo "&lt;td&gt;".$row['F.Name']."&lt;/td&gt;";
             echo "&lt;td&gt;".$row['D.Name']."&lt;/td&gt;";
             echo "&lt;td&gt;".$row['G.Genre']."&lt;/td&gt;";
             echo "&lt;td&gt;".$row['R.Rating']."&lt;/td&gt;";
             echo "&lt;td&gt;".$row['T.ThreeDeeOption']."&lt;/td&gt;";
             echo "&lt;/tr&gt;";
         }
  
      ?&gt;
  &lt;/table&gt;
  </code></pre>