我在数据库上有一个字段，名称是Time_message，我设置这个日期的默认值是w, d-m-Y H:i:s，我想使用BETWEEN和一个值来创建一些搜索，只是显示"d-m-Y"我怎么能把它显示给我的查询?
我把我的代码放在下面…
$date1 = "21-08-2015";
$date2 = "d-m-Y";
$query = mysql_fetch_array(mysql_query("SELECT COUNT(*) as jumlahdata FROM message_complaint WHERE (status_message='".$data['status_message']."') AND (time_message BETWEEN $date1 AND $date2)"));
您的MySQL和MySQLi冲突。使用MySQLi
$date1 = "21-08-2015";
$date2 = "d-m-Y";
$message = $data['status_message'];
$query = mysqli_query($con, "SELECT COUNT(*) as jumlahdata FROM message_complaint WHERE (status_message='$message') AND (time_message BETWEEN '$date1' AND '$date2')");
$row = mysqli_fetch_array($query, MYSQLI_ASSOC);
$con= mysqli connection