Query 2 Table MySQLได้ แต่ รัน PHP ไม่ได้ ครับ ช่วยดูหน่อย

@mysql_num_rows

$result=mysql_db_query($dbname,$sql);
$record_num=@mysql_num_rows($result);
$i=0;
while ($i < $record_num){
$record=mysql_fetch_array($result)
$id_vdo=$record[id_vdo];

$result=mysql_db_query($dbname,$sql) or die ("error sql "); // พิมพ์   or die ("error sql ");  ลองเช็คดูก่อนครับว่า  ชุด $sql  เราผิดหรือเปล่าครับ

$record_num=@mysql_num_rows($result);
$i=0;
while ($i < $record_num){

$record=mysql_fetch_array($result); // ผมพิมพ์ตก ; ไปตัวครับ

$id_vdo=$record[id_vdo];

include "connect.php";


mysql_query("SET NAMES tis620");
$sql="SELECT title_eleanning.id_vdo,title_eleanning2.id_vdo2,title_eleanning.s_title_vdo,title_eleanning.title_vdo,title_eleanning2.title_vdo2,
title_eleanning.detail_vdo,title_eleanning2.script_vdo
from title_eleanning
left outer join title_eleanning2 on title_eleanning.ref_id = title_eleanning2.ref_id
order by title_eleanning.ref_id desc";
$result=mysql_db_query($dbname,$sql);
$record_num=mysql_num_rows($result);
$i=0;
while ($record=mysql_fetch_array($result)){

$id_vdo=$record[id_vdo];
$id_vdo2=$record[id_vdo2];
$s_title=$record[s_title_vdo];
$title_vdo=$record[title_vdo];
$title_vdo2=$record[title_vdo2];
$detail_vdo=$record[detail_vdo];
$script_vdo=$record[script_vdo];
echo "$id_vdo";
echo "<br>";
echo "$id_vdo2";
echo "<br>";
echo "$s_title";
echo "<br>";
echo "$title_vdo";
echo "<br>";
echo "$title_vdo2";
echo "<br>";
echo "$detail_vdo";
echo "<br>";
echo "$script_vdo";
echo "<br>";
}



mysql_close();