Ternyata menghitung jumlah hari cukup mudah dengan sintak SQL, langsung ajah…, nie potongan scriptnya:

<?php
$datestart = “2010-10-13”;
$dateakhir = “2010-10-31”;

$query = “SELECT datediff(‘$dateakhir’,’$dateawal’) as selisih”;
$hasil = mysql_query($query);
$data = mysql_fetch_array($hasil);
$jmlhari = $data[‘selisih’];

?>

Nah itu aja, simple dan easy hehehe…,

By

42 thoughts on “Menghitung Jumlah Hari Dengan SQL”

Leave a Reply to laporan praktikum Cancel reply

Your email address will not be published. Required fields are marked *