ผมเรียกข้อมูลมาแสดง 2 แบบนี้ แบบไหนดีกว่ากันครับ...

	$id=5;
	$sql="select * from tb_products where id_product='$id'";
	$result=mysql_db_query($dbname,$sql);
	$record=mysql_fetch_array($result);
				$id_product=$record[id_product];
				$code_product=$record[code_product];
				$name_product=$record[name_product];

	$sql_img="select * from tb_file where ref_id ='$id' and ref_file='product' order by id_file desc";
	$result_img=mysql_db_query($dbname,$sql_img);
	$num_rows=mysql_num_rows($result_img);
	while ($record_img=mysql_fetch_array($result_img)){
		$id_file=$record_img[id_file];
		$name_file_b=$record_img[name_file];
		$file_type=$record_img[file_type];
		$ref_id=$record_img[ref_id];
		$ref_file=$record_img[ref_file];
	}

	$id=5;
	$sql="SELECT tb_products.*,tb_file.* FROM tb_products,tb_file WHERE tb_products.id_product =$id and tb_file.ref_id=$id and tb_file.ref_file='product'";
	$result=mysql_db_query($dbname,$sql);
	while($record=mysql_fetch_assoc($result)){
			echo $record["name_file"]."<br />";
	}
	$result=mysql_db_query($dbname,$sql);	
	$record=mysql_fetch_assoc($result);
	echo "ชื่อสินค้า : ".$record["code_product"]."<br />";	
	echo "ชื่อสินค้า : ".$record["name_product"]."<br />";
	mysql_free_result($result);