PHP MYSQL : : อยากเรียกมาแสดงเฉพาะ ไอดี ล่าสุดของอีกตารางนึงอะคับ ต้องทำยังไงคับผม

<?
	$strSQL = "SELECT * FROM vdo WHERE vdo_id = vdo_id  ORDER BY vdo_id DESC LIMIT 0,1";
	$objQuery = mysql_query($strSQL);
	$objResult = mysql_fetch_array($objQuery);
	echo $objResult['vdo_link'];
?>
	<a class="vol" href='?op=reback' 
	onmouseout="MM_swapImgRestore()" .
    onmouseover="MM_swapImage('vol','','loop.jpg',1)">
    <img src="n_loop.jpg" name="vol" width="110" height="110" border="0" id="vol" /></a>
    </div><!-- TV and Link Stop-->
   
 </div><!-- Content Stop-->

   <table class="comment_table">
   
   <tr><td colspan="2"></td></tr>
  <tr>
  <td align="center"> <img class="comment_logo" src="image/comment_h.png" /></td>
<td>  <form class="comment_form" action='?op=comment_process' method="post"> <!-- Comment Form Start-->
 <textarea class="input" cols="40" name="comment" rows="5"></textarea><br />
<? $strSQL = "SELECT * FROM member WHERE mem_id = '".$_SESSION['mem_id']."' ";
	$objQuery = mysql_query($strSQL);
	$objResult = mysql_fetch_array($objQuery);
	?>
 	<input type="hidden" name="username" value=<? echo $objResult['username'] ?> >
  	<input type="image" src="image/bc.png" value="Submit" />
  <!--Comment Form Stop -->
 </form></td></tr>
 <tr>
 <td colspan="2">
 <? $query = "SELECT * FROM comment ORDER BY comment_date DESC";
    $resault = mysql_query($query);
	while($record=mysql_fetch_array($resault))
	if($record [comment] !== ""){
   {?>
 <div id="fieldset_top"></div>
  <div id="fieldset_center">
 <p class="p_left">
 
  #3&nbsp;<strong class="strong">
  <? echo $record[username]; ?>
  </strong> 
  
 <small class="small">
<? echo $record[comment_date];?>
  </small>
 <br />
<? echo $record[comment]; ?>
 </p>
  </div>
  <div id="fieldset_botton"></div>
<? } ?>
  </td></tr>
  </table>
    
  <? }