$str = explode("-",$clientname);
$date1=$str[0];
$date2=$str[1];
$date3=$str[2];
$date4=$str[3];
$date5=$str[4];
$date6=$str[5];
$query0 ="SELECT cwid from caiwu WHERE Uid='".$userid."'and cwdate(date, '%Y-%m-%d') >= '$date1-$date2-$date3' and cwdate(date, '%Y-%m-%d') <= '$date4-$date5-$date6' group by Hid";这个$clientname是自己输入里面的比如“2012-11-20-2012-11-30”,我这种写错在哪里,它怎么会提示这种的错误:mysql Error: 1305
SELECT cwid from caiwu WHERE Uid='1'and cwdate(date, '%Y-%m-%d') >= '2012-11-26' and cwdate(date, '%Y-%m-%d') <= '2012-11-28' group by Hid
高手请指教,谢谢!
$date1=$str[0];
$date2=$str[1];
$date3=$str[2];
$date4=$str[3];
$date5=$str[4];
$date6=$str[5];
$query0 ="SELECT cwid from caiwu WHERE Uid='".$userid."'and cwdate(date, '%Y-%m-%d') >= '$date1-$date2-$date3' and cwdate(date, '%Y-%m-%d') <= '$date4-$date5-$date6' group by Hid";这个$clientname是自己输入里面的比如“2012-11-20-2012-11-30”,我这种写错在哪里,它怎么会提示这种的错误:mysql Error: 1305
SELECT cwid from caiwu WHERE Uid='1'and cwdate(date, '%Y-%m-%d') >= '2012-11-26' and cwdate(date, '%Y-%m-%d') <= '2012-11-28' group by Hid
高手请指教,谢谢!
字符串函数能被你折腾成这样,伤不起~
1 echo $query0 看看你究竟在折腾啥.
2 在拼接之前,就把$date1 $date2 组装好。 不要再增加sql 字符串拼接的复杂度了.