and then i use date() function to format it the way i like...
but i'm not sure about the mktime() function i'm using rite now...
this is my snippet of code:
Code: Select all
$mulaServis=$_POST["mulaServis"];
$tamatServis=$_POST["tamatServis"];
$start=mktime($mulaServis,$day, $month, $year);
$end=mktime($tamatServis,$day, $month, $year);this is my query:
Code: Select all
$viewall=query("Select * from preventiveMaint WHERE preventiveMaint.waktuTamat BETWEEN '$start' AND '$end'", $link, __LINE__, __FILE__);pls help me...