How to display data from two data table in one table
<p>I have two tables, <code>image</code> and <code>video</code>. I want to display all data from image and video in one table. I know how to display all data from video but how to display all data from image also in same table. There is table where I display all data from video but can someone please tell me how to display all data from images in same table when displaying data from video is finished.</p>

<pre><code>&lt;table width="879" border="2" cellpadding="3" cellspacing="1"&gt;
  &lt;tr&gt;
    &lt;td colspan="11" align="center" &gt;&lt;strong&gt;All uploaded videos&lt;/strong&gt;
    &lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td width="51" align="center" bgcolor="#000000" class="yellow"&gt;&lt;strong&gt;Id&lt;/strong&gt;&lt;/td&gt;
    &lt;td width="95" align="center" bgcolor="#000000" class="yellow"&gt;&lt;strong&gt;Video&lt;/strong&gt;&lt;/td&gt;
    &lt;td width="83" align="center" bgcolor="#000000" class="yellow"&gt;&lt;strong&gt;Name&lt;/strong&gt;&lt;/td&gt;
    &lt;td width="130" align="center" bgcolor="#000000" class="yellow"&gt;&lt;strong&gt;Date&lt;/strong&gt;&lt;/td&gt;
    &lt;td width="177" align="center" bgcolor="#000000" class="yellow"&gt;&lt;strong&gt;Description&lt;/strong&gt;&lt;/td&gt;
    &lt;td width="101" align="center" bgcolor="#000000" class="yellow"&gt;&lt;strong&gt;Price&lt;/strong&gt;&lt;/td&gt;
    &lt;td width="174" align="center" bgcolor="#000000" class="yellow"&gt;&lt;strong&gt;Added by&lt;/strong&gt;&lt;/td&gt;
  &lt;/tr&gt;

  &lt;?php $path= "videoFile/";
    while($rows=mysql_fetch_array($result1)){
  ?&gt;

  &lt;tr&gt;  
    &lt;td&gt;
      &lt;?php if ( current_user_can( 'manage_options' ) ) { echo $rows['vid'];}else { echo "For admins only!"; }  ?&gt;
    &lt;/td&gt;
    &lt;td&gt;&lt;a href="&lt;?php echo $path.$rows['filename'] ?&gt;"&gt;View video&lt;/a&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $rows['alttext']; ?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $rows['imagedate']; ?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $rows['description']; ?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo "$".$rows['price']; ?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $rows['user_nicename']; ?&gt;&lt;/td&gt;    
  &lt;/tr&gt;

  &lt;?php
    }
  ?&gt;    
&lt;/table&gt;
</code></pre>
