if ($total>0){
$sql="SELECT * from duoduo_myquanlog where TO_DAYS(qu_date)>=TO_DAYS(now()) and qu_username='".$_SESSION['ddusername']."'";
$rs = mysql_query($sql);
$total1 = mysql_num_rows($rs);
if ($total1<1){
$sql="select * from ".$BIAOTOU."youhuiquan,duoduo_mall where duoduo_youhuiquan.qu_mallid=duoduo_mall.id and qu_id='".$mall_id."'";//获取优惠券信息
$query=mysql_query($sql);
$mall=mysql_fetch_array($query);
$quan_str='您好,你的优惠券发放成功!<br>优惠券卡号是:'.$mall('qu_num');
if($mall('qu_pwd')!=''){
$quan_str=$quan_str.'<br>密码:'.$mall('qu_pwd');
}
$quan_str=$quan_str.'<br>请在:'.$mall('qu_daoqi').'前使用,否则优惠券会失效!同时请一定单击下面的链接到商城购物:<br><a href=mall.php?id=';
$quan_str=$quan_str.$mall('id').'>马上拿优惠券去'.$mall('name').'购物</a>';
$isfafang=1;
$insert="UPDATE ".$BIAOTOU."youhuiquan set qu_isuse=1 where qu_id=".$mall_id;
mysql_query($insert);
echo $quan_str;
}
else
....后面的没有出错,就是进入上面的条件时才出错的
$sql="SELECT * from duoduo_myquanlog where TO_DAYS(qu_date)>=TO_DAYS(now()) and qu_username='".$_SESSION['ddusername']."'";
$rs = mysql_query($sql);
$total1 = mysql_num_rows($rs);
if ($total1<1){
$sql="select * from ".$BIAOTOU."youhuiquan,duoduo_mall where duoduo_youhuiquan.qu_mallid=duoduo_mall.id and qu_id='".$mall_id."'";//获取优惠券信息
$query=mysql_query($sql);
$mall=mysql_fetch_array($query);
$quan_str='您好,你的优惠券发放成功!<br>优惠券卡号是:'.$mall('qu_num');
if($mall('qu_pwd')!=''){
$quan_str=$quan_str.'<br>密码:'.$mall('qu_pwd');
}
$quan_str=$quan_str.'<br>请在:'.$mall('qu_daoqi').'前使用,否则优惠券会失效!同时请一定单击下面的链接到商城购物:<br><a href=mall.php?id=';
$quan_str=$quan_str.$mall('id').'>马上拿优惠券去'.$mall('name').'购物</a>';
$isfafang=1;
$insert="UPDATE ".$BIAOTOU."youhuiquan set qu_isuse=1 where qu_id=".$mall_id;
mysql_query($insert);
echo $quan_str;
}
else
....后面的没有出错,就是进入上面的条件时才出错的
这个语句打出来看看,这个语句一看就有问题
if ($total>0){
$sql="SELECT * from duoduo_myquanlog where TO_DAYS(qu_date)>=TO_DAYS(now()) and qu_username='".$_SESSION['ddusername']."'";
$rs = mysql_query($sql);
$total1 = mysql_num_rows($rs);
if ($total1<1){
$sql="select * from ".$BIAOTOU."youhuiquan,duoduo_mall where duoduo_youhuiquan.qu_mallid=duoduo_mall.id and qu_id='".$mall_id."'";//获取优惠券信息
$query=mysql_query($sql);
$mall=mysql_fetch_array($query);
$quan_str='您好,你的优惠券发放成功!<br>优惠券卡号是:'.$mall('qu_num');
if($mall('qu_pwd')!=''){
$quan_str=$quan_str.'<br>密码:'.$mall('qu_pwd');
}
$quan_str=$quan_str.'<br>请在:'.$mall('qu_daoqi').'前使用,否则优惠券会失效!同时请一定单击下面的链接到商城购物:<br><a href=mall.php?id=';
$quan_str=$quan_str.$mall('id').'>马上拿优惠券去'.$mall('name').'购物</a>';
$isfafang=1;
$insert="UPDATE ".$BIAOTOU."youhuiquan set qu_isuse=1 where qu_id=".$mall_id;
mysql_query($insert);
echo $quan_str;
}
else
if ($total>0){
error_reporting(E_ALL); //加上这一句试试
...
$query=mysql_query($sql);
改为:
if (!$query = mysql_query($sql)) die(mysql_error());mysql_query($insert);
改为:
if (!mysql_query($insert)) die(mysql_error());
$insert="UPDATE ".$BIAOTOU."youhuiquan set qu_isuse=1,qu_usedata=now() where qu_id=".$mall_id;
mysql_query($insert);
这个语句是不是没有执行,好像没有更新一样