อยากรู้ วิธีทำระบบสุ่มแบนเนอร์ (Random Banner With PHP)

<?
 mysql_connect("localhost","root","root");
 mysql_select_db("thaicreate");
 $strSQL = "SELECT * FROM banner WHERE 1 ORDER BY RAND() LIMIT 1 ";
 $objQuery = mysql_query($strSQL);
 $objResult = mysql_fetch_array($objQuery);
 if($objResult)
 {
	echo "<img src='path/".$objResult["img-name"]."'>";
 }
?>

<?
include "connect.php";
$sql = "Select Min(no) minimum From tb_banner;";
$result = mysql_query($sql);
while ($dbarr = mysql_fetch_array($result))
{
$min = $dbarr['minimum'];
}

$sql = "Select Max(no) maximum From tb_banner;";
$result = mysql_query($sql);
while ($dbarr = mysql_fetch_array($result))
{
$max = $dbarr['maximum'];
}

$random_banner = rand($min,$max);

$sql = "Select * From tb_banner Where no = $random_banner;";
$result = mysql_query($sql);
while ($dbarr = mysql_fetch_array($result))
{
$photo_file = $dbarr['photo'];
}
echo  "<img scr=$photo_file border=0>";
mysql_close($link);
?>

<?
	$sql="SELECT  *  FROM  promotion  ORDER BY RAND()LIMIT 1 ";
	$result=$DB->query($sql);
	$row=$DB->fetch_array($result);
?>
    <img src="admin/promotion/promotion/<?=$row['img_pro']?>"  width="975" height="546" alt="">