public function test(){
$db = M('send_log');
$condition['openid'] = 'oTPWJjuPj6mU6kx-KWhSDSnI7Fl4';
$condition['week'] = date("YW");
$condition['game'] = 'texas';
var_dump($condition);
$num = $db->where($condition)->find();
echo $db->getLastSql();
var_dump($num);
}
打印出来
array(3) { ["openid"]=> string(28) "oTPWJjuPj6mU6kx-KWhSDSnI7Fl4" ["week"]=> string(6) "201334" ["game"]=> string(5) "texas" }
SQL语句居然没有game条件！！
SELECT * FROM `send_log` WHERE ( `openid` = 'oTPWJjuPj6mU6kx-KWhSDSnI7Fl4' ) AND ( `week` = 201334 ) LIMIT 1
最佳答案
