我在网上参考MySQL的DATE_FORMAT函数试写了一个sql语句(select * from articles where DATE_FORMAT(create_time, "%M %Y")='.date("F Y",strtotime($store)),$store的格式是“January 2009”,我想把它转为时间格式,转换后还是“January 2009”,不过运行后却显示“Call to a member function fetch_assoc() on a non-object”错误,错误的地方就是我写的SQL语句那,究竟该怎么写呢
$sql = select * from articles where DATE_FORMAT(create_time, '%Y-%d') = '". date("Y-m",strtotime($store)). "'";
//第二种
$sql = select * from articles where DATE_FORMAT(create_time, '%M %Y') = "$store'";
有些时候还要自已定义mysql的函数呢,mysql自带的函数为什么不用.