<?php教程
$bbsconn=mysql教程_connect("localhost","root","");
mysql_select_db("lsmsql",$bbsconn);
$kind="幻燈片";
$sql="select * from sa_article where kind='$kind' order by articleid desc limit 0,6";
$result=mysql_query($sql);
$pics=$links=$texts="";
while ($rows=mysql_fetch_array($result)){
$pics.="/attached/".$rows['source']."|";
$links.="show.php?id=".$rows['articleid']."|";
$texts.=$rows['title']."|";
}
$pics=substr($pics,0,-1);
$links=substr($links,0,-1);
$texts=substr($texts,0,-1);
?>
<!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "HTTP://www.w3.org/tr/xhtml1/dtd/ xhtml1-transitional.dtd">
<html xmlns="HTTP://www.w3.org/1999/xhtml">
<head>
<meta HTTP-equiv="content-type" content="text/html; charset=gb2312" />
<title>幻燈片</title>
</head>
<body>
<table width="300" border="1">
<tr>
<td>
<script type=text/網頁特效>
<!--
var focus_width=300;
var focus_height=200;
var text_height=20;
var swf_height = focus_height+text_height
var pics="<?=$pics?>"
var links="<?=$links?>"
var texts="<?=$texts?>"
document.write('<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="HTTP:// fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="'+ focus_width +'" height=" '+ swf_height +'">');
document.write('<param name="allowscriptaccess" value="samedomain"><param name="movie" value=" playswf.swf"><param name=wmode value=transparent><param name="quality" value="high">');
document.write('<param name="menu" value="false"><param name=wmode value="opaque">');
document.write('<param name="flashvars" value="pics='+pics+'&links='+links+'&texts='+texts+'& borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'">');
document.write('<embed src="playswf.swf" wmode="opaque" flashvars="pics='+pics+'&links='+links+'&texts ='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'" menu="false" bgcolor="#dadada" quality="high" width="'+ focus_width +'" height="'+ swf_height +'" allowscriptaccess=" samedomain" type="application/x-shockwave-flash" pluginspage="HTTP://www.macromedia.com/go/getflashplayer" />' ); document.write('</object>');
//-->
</script>
</td>
</tr>
</table>
</body>
</html>