需要帮助Mysql选择查询

I have a field on database, the name is Time_message, and I set default for this date is w, d-m-Y H:i:s, and I wanna create some search using BETWEEN and a value just show "d-m-Y" how can i show it to my query??

I bring my code below..

$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)"));

you are conflicting MySQL and MySQLi. Use 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 equal to mysqli connection