mhn bantuan nya dari para suhu
saya coba membuat filter inbox berdasarkan range tanggal namun masih saja ada kesalahan converting tanggal
//tanggal
$now = time();
$akhir = mktime(date("H", $now), date("i", $now), date("s", $now), date("m", $now), date("d", $now), date("Y", $now));
$awal = mktime(date("H", $now), date("i", $now), date("s", $now), date("m", $now), date("d", $now), date("Y", $now));
//$start = date('Y m d H:i:s',$awal); //13 Mar 2015 01:22:45
$start = date('Y m d H:i:s',$awal); //2015-03-04 00:00
$end = date('Y m d H:i:s',$akhir);
$sekarang = date('Y m d H:i:s',$akhir);
$q = mssql_query("select * from inbox where tgl_entri >= '$start' and tgl_entri <= '$end' "); //line 16
hasil nya
Warning: mssql_query() [function.mssql-query]: message: Conversion failed when converting datetime from character string. (severity 16) in D:\xampp\htdocs\report\inc_inbox.php on line 16
Warning: mssql_query() [function.mssql-query]: Query failed in D:\xampp\htdocs\report\inc_inbox.php on line 16
trimakasih