I queried:
select *
from marrydays
where YMD_X like '2010-1-%'
and marrydays.CONG not like 'aa%'
and marrydays.CONG not like 'bb%' ;
But after I use mysql_fetch_object function,I didn't got exact result,the result just like I queried :
select * from marrydays where YMD_X like '2010-1-%' ;
Why?
Some code pieces:
$res1 = $db->find("select * from marrydays where YMD_X like"." '".$cnDate."%' and CONG not like '冲".$male_shu."%' ;");
public function find($sql, $key=null){ $data = array(); $result = $this->query($sql); while($row = mysql_fetch_object($result)){ if(!empty($key)){ $data[$row->{$key}] = $row; }else{ $data[] = $row; } } return $data; }
public function query($sql){
$stime = microtime(true);
$result = mysql_query($sql, $this->conn);
$this->query_count ++;
if($result === false){
throw new Exception(mysql_error($this->conn)." in SQL: $sql");
}
$etime = microtime(true);
$time = number_format(($etime - $stime) * 1000, 2);
$this->query_list[] = $time . ' ' . $sql;
return $result;
}