GETDATE() order by id desc"; //$sql="select top 100 id,CouponNO,CouponName,CouponMoney,CouponDate_Ent=convert(varchar(21),CouponDate_Ent,111),CouponState from Coupon where CouponState=0 and ToOAid=0 and CouponDate_Ent>GETDATE() order by id desc"; $data = sqlsrv_query($conn,$sql); if($data == true){ if (sqlsrv_rows_affected($data)!=0) { while($rs = sqlsrv_fetch_array($data) ) { $i++; if (mb_strlen($rs["CouponName"],'UTF-8')>5){ $CouponName=mb_substr($rs["CouponName"],0,5)."..."; }else{ $CouponName=$rs["CouponName"]; } ?>

没有找到相关的数据

名称	金额	有效期	状态
">			未派送"; }elseif ($rs["CouponState"]==0){ echo "未使用"; }elseif ($rs["CouponState"]==1){ echo "已使用"; }else { echo "无效"; } ?>