die('Could not connect: ' . mysql_error());
}
$time = time();
$con->query(select * from a where pubdate < $time);
?>
5. php mysql三个表的内连接语句怎么写 SELECT s.shoptitle,s.pic , s.mid ,s.sid,ff.GuangGaoFuFei ,ff.ffid,ff.mid,m.mid,m.shopname,m.user from money AS ff INNER JOIN tb_storeinfos AS s ON ff.sid=s.sid INNER JOIN tb_members AS m ON s.mid=m.mid where ff.GuangGaoFuFei='1' AND m.shopname!=''
ORDER BY ff.GuangGaoKaiShi DESC,m.mid limit 0,12
6. php怎么写这样的mysql 循环语句 // 我猜你想取图片地址if(empty($spbm)){ $sql = "select * from newjianyan where spbm='$spbm' AND zshm='$zshm AND wjm='$wjmmem' "；//字符变量单引号$res = mysql_query($sql); while($row = mysql_fetch_assoc($res)） { //组成图片地址 $unlink_res = "/wwwroot/gyszj/newjianyan/".$row['图片名称字段'].".jpg"； //验证删除 if(unlink($unlink_res)） { //同时删除数据库中的数据 $delete_res =mysql_query("delete from newjianyan where spbm='$spbm' AND zshm='$zshm' AND wjm='$wjmmem'") ; } }} 。