title: how to display other table data in $row = mysql_fetch_row
body: <p>I have 3 tables: <code>te_event</code>, <code>te_venue</code>, <code>te_category</code>.<br/></p>
  
  <ul>
  <li><p><code>te_event</code> table has columns: <code>categoryID</code>, <code>venueID</code>, <code>event description</code>, <code>title</code>, <code>date</code>, <code>price</code>.<br/></p></li>
  <li><p><code>te_venue</code> table has columns: <code>venueID</code>, <code>venueName</code> and <code>location</code>.<br/></p></li>
  <li><p><code>te_category</code> has columns: <code>catID</code> and <code>catDesc</code>.<br/></p></li>
  </ul>
  
  <p>and here is my sql query:</p>
  
  <pre><code>$sqlEvent =" SELECT * FROM te_events 
                   INNER JOIN te_venue ON te_events.venueID = te_venue.venueID 
                   INNER JOIN te_category ON te_events.catID = te_category.catID
                   WHERE eventID =" .$id;
  </code></pre>
  
  <p>If I use <code>row[]</code> to retrieve data from <code>te_events</code>, the <code>row[ *number]</code> depends on the <code>te_events</code> column.<br/>
  So how do I retrieve other table data by using <code>row[*number]</code>?</p>