这个php代码18行错误提示

[qq_28670221]

<?php
set_time_limit(0);
include("data/config.php");

$link=mysql_connect($db_host,$db_user,$db_pass)or die("connect error");
mysql_select_db($db_name,$link)or die(mysql_error());
mysql_query("set names utf8");

header("Content-type:text/html;charset=utf-8");

$id=intval($_GET['id']);


if($id==0){

$sql="select `goods_id`,`goods_name`,`goods_desc` from `p_goods` order by goods_id desc ";
$res=mysql_query($sql);
while($row=mysql_fetch_array($res))
{
$aa="<span style='color:#ccc;font-size:12px;'>无远程图片</span>";
if(preg_match('/(http:\/\/)/i', $row['goods_desc'])){
$aa="<a target='_blank' href='?id=".$row['goods_id']."'>Go Get It</a>";
}
echo $row['goods_id']." ".$row['goods_name']." ".$aa."<br/>";
}

exit();
}





sleep(1);


$sql="select `goods_desc` from `p_goods` where `goods_id`='$id' limit 1";
$res=mysql_fetch_array(mysql_query($sql));

preg_match_all('/src=[\'|"]([^"|^\']+)[\'|"]/i', $res[0], $picurl);
$urlArr=$picurl[1];
/*
print_r($urlArr);
die();
$urlArr[]="http://static.oschina.net/uploads/user/129/258733_50.jpg";
$urlArr[]="http://static.oschina.net/uploads/img/201302/16195715_kPci.png";
*/
$num= isset($_GET['num']) ? $_GET['num'] : 1;

$all=count($urlArr);


$url=$urlArr[$num-1];


if(!preg_match('/(http:\/\/)/i', $url)){
if($num >= $all) {
exit('<br/>all done!');
}
echo $url."<br/> 已处理";
echo "<script>location.href='?id={$id}&num=".($num+1)."'</script>";
exit();
}



$array=@get_headers($url,1);

echo $url."<br/><br/>";

if(preg_match('/200/',$array[0])){

ob_start();
readfile($url);
$img = ob_get_contents();
ob_end_clean();
$dir="images/goods_desc";

if (!file_exists($dir))
{
mkdir($dir, 0777);
}

$filename=$dir."/".mt_rand(11111,9999999999).time().".jpg";
$f=fopen($filename,'a');
$fres=fwrite($f,$img);
fclose($f);

if($fres!=false){
$goods_desc=str_replace($url,"/".$filename,$res[0]);
$sql="update `p_goods` set `goods_desc` = '$goods_desc' where `goods_id`='$id' limit 1 ";
mysql_query($sql);
}

}

echo $num."/".$all;

if($num >= $all) {

exit('<br/>all done!');
}
else{

echo "<script>location.href='?id={$id}&num=".($num+1)."'</script>";
}




?>

[小菜鸟czh]

你的sql语句出错了 $sql="select `goods_id`,`goods_name`,`goods_desc` from `p_goods` order by goods_id desc "; $res=mysql_query($sql); 这句语句错了

[果酱很好吃]

$res=mysql_query($sql); 后面判断一下，是否有数据返回 if($res){ while($row=mysql_fetch_array($res)) { } } 把你sql那到mysql里面去运行一下， 看是否有数据或者错误

[xuzuning]

17行改为 $res=mysql_query($sql) or die(mysql_error()); 前面不易出错的地方你都加了错误处理 为何在容易出错的地方却又不加呢？

[侑子的小伙伴]

mysql_query 执行失败

[xyz_jink]

mysql_fetch_array()这里面只接收资源类型的参数，而楼主给的却是个执行函数因此就报错了。可以先var_dump(mysql_query($sql))看看是个什么，就自然明白为何报错

[pengjf]

把SQL中的单引号去掉