信息发布系统，有图片的新闻。首页要显示最新发布的有图片的新闻的图片。如首页.能够自动加载最新X片新闻的图片且可以自动切换。
------解决方案--------------------------------------------------------
select top 5 picture_name from PictureTable order by PictureData Desc
从图片表里取出最新的图片。 给fresh, 或者js作为数据源，切换好了，图片切换的程序，网上很多。
------解决方案--------------------------------------------------------
你需要代码，就留个联系方式吧，要不有代码也没法给你呀，而且套个flash
------解决方案--------------------------------------------------------
我这边有一个，lz看看
<script type="text/javascript">
var focus_width=299//图片宽200
var focus_height=245//图片高130
var text_height=20//设置显示文字标题高度,最佳为20（如果不显示标题值设为0即可）
var swf_height = focus_height+text_height
//var pics=""
//var links=""
//var texts=""
var pics='<%=pics %>'
var links='<%=links %>'
var texts='<%=texts %>'
document.write('<object ID="focus_flash" 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="images/focus.swf"><param name="quality" value="high"><param name="bgcolor" value="#FFFFFF">');
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 ID="focus_flash" src="images/focus.swf" wmode="opaque" FlashVars="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'" menu="false" bgcolor="#C5C5C5" 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>