用ADODB:
include("$adodb_path/adodb.inc.php");
$dbconn=NewADOConnection($database_type);
$db->Connect($host,$user,$password,$db_name);$sql="select id,picname,picurl from etpic"
$rs=$dbconn->Execute($sql);
while(!$rs->EOF)
{
echo "bannerAD[".$rs->fields['id']."]=\"http://bbsimg.qq.com".$rs->fields['picname']."\";\n"
echo "bannerADlink[".$rs->fields['id']."]=\"".$rs->fields['picurl']."\";\n"
$rs->MoveNext();
}
$dbconn=NewADOConnection($database_type);
$db->Connect($host,$user,$password,$db_name);$sql="select id,picname,picurl from etpic";
$rs=$dbconn->Execute($sql);
while(!$rs->EOF)
{
echo "bannerAD[".$rs->fields['id']."]=\"http://bbsimg.qq.com".$rs->fields['picname']."\";\n";
echo "bannerADlink[".$rs->fields['id']."]=\"".$rs->fields['picurl']."\";\n";
$rs->MoveNext();
}
$dbconn=mysql_connect($host,$user,$password);
mysql_select_db($db_name,$dbconn);$sql="select id,picname,picurl from etpic";$rs=mysql_query($sql);while ($fields = mysql_fetch_row($rs))
{echo "bannerAD[".$fields['id']."]=\"http://bbsimg.qq.com".$fields['picname']."\";\n";
echo "bannerADlink[".$fields['id']."]=\"".$fields['picurl']."\";\n";}
<SCRIPT language=JavaScript>
<!-- // BannerAD
var bannerAD=new Array();
var bannerADlink=new Array();
var adNum=0;
<?php
include("$adodb_path/adodb.inc.php");
$dbconn=NewADOConnection($database_type);
$db->Connect($host,$user,$password,$db_name);$sql="select id,picname,picurl from etpic";
$rs=$dbconn->Execute($sql);
while(!$rs->EOF)
{
echo "bannerAD[".$rs->fields['id']."]=\"http://bbsimg.qq.com".$rs->fields['picname']."\";\n";
echo "bannerADlink[".$rs->fields['id']."]=\"".$rs->fields['picurl']."\";\n";
$rs->MoveNext();
}
?>
var preloadedimages=new Array();
...............................
..............................
//后面的一样
<!-- // BannerAD var bannerAD=new Array();
var bannerADlink=new Array();
var adNum=0;
<?php
$rightpic=array();
$rightpic=getmkpic($mkid);
$lists=sizeof($rightpic);
for($row=0;$row<$lists;$row++){
// echo "bannerAD[".$rs->fields['id']."]=\"http://bbsimg.qq.com".$rs->fields['picname']."\";\n";
echo "bannerAD[".$rightpic[$row][0]."]=\"http://192.168.1.11/zysc/".$rightpic[$row][2]."\";\n";
echo "bannerADlink[".$rightpic[$row][0]."]=\"#\";\n";
}
?>
echo "bannerADlink[".$rightpic[$row][0]."]=\"#\";\n";
改为如下即可echo "bannerAD[".$rightpic[$row][0]."]=\"http://192.168.1.11/zysc/".$rightpic[$row][2]."\"\n";
echo "bannerADlink[".$rightpic[$row][0]."]=\"#\"\n";
<?php
$rightpic=array();
$rightpic=getmkpic($mkid);
$lists=sizeof($rightpic);
for($row=0;$row<$lists;$row++){
// echo "bannerAD[".$rs->fields['id']."]=\"http://bbsimg.qq.com".$rs->fields['picname']."\";\n";
echo "bannerAD[".$rightpic[$row][0]."]=\"http://192.168.1.11/zysc/".$rightpic[$row][2]."\"\n";
echo "bannerADlink[".$rightpic[$row][0]."]=\"#\"\n";
}
?>
思路已经告诉你啦,有些小错误你应该学会自己搞定。
真的找不出来的时候再上来问。<?php
$rightpic=array();
$rightpic=getmkpic($mkid);
$lists=sizeof($rightpic);
for($row=0;$row<$lists;$row++){
// echo "bannerAD[".$rs->fields['id']."]=\"http://bbsimg.qq.com".$rs->fields['picname']."\";\n";
echo "bannerAD[".$row."]=\"http://192.168.1.11/zysc/".$rightpic[$row][2]."\"\n";
echo "bannerADlink[".$row."]=\"#\"\n";
}
?>
bannerADlink[0]="http://news.qq.com/a/20051007/000382.htm";
若
bannerAD、bannerADlink分别对应picname、picurl
循环读取记录到$row中则
$i = 0;
while($row = ....) {
echo "bannerAD[$i]=\"$row[picname]\";\n";
echo "bannerADlink[$i]=\"$row[picurl]\";\n";
$i++;
}
楼主也是,查看源文件看下代码比对下不就知道问题在哪里了么<?php
$rightpic=array();
$rightpic=getmkpic($mkid);
$lists=sizeof($rightpic);
for($row=0;$row<$lists;$row++){
// echo "bannerAD[".$rs->fields['id']."]=\"http://bbsimg.qq.com".$rs->fields['picname']."\";\n";
echo "bannerAD[".$row."]=\"http://192.168.1.11/zysc/".$rightpic[$row][2]."\";\n";
echo "bannerADlink[".$row."]=\"#\";\n";
}
?>
http://192.168.1.11/zysc/undefined急,高手帮忙!