i try my best to set date as my database accept it but when i give date like 9/10/2004 it must be converted to 2004-09-10 but it come like this 2004/9/10 so database give error of date format please guid me. as my script to conver date is
switch($_REQUEST["i"])
{
case "w2d": $from1=date("m/d/Y",mktime(0,0,0,date("m"),date("d")-7,date("Y")));$to1=date("m/d/Y");break;
case "m2d": $from1=date("m/1/Y");$to1=date("m/d/Y");break;
case "y2d": $from1=date("01/01/Y");$to1=date("m/d/Y");break;
default: $from1=date("01/01/Y");$to1=date("m/d/Y");break;
}
if($_REQUEST["from1"]!="") {$from1=$_REQUEST["from1"];}
if($_REQUEST["to1"]!="") {$to1=$_REQUEST["to1"];}
$tempfrom=explode("/",$from1);
$date1=$tempfrom[2]."-".$tempfrom[0]."-".$tempfrom[1];
$tempto=explode("/",$to1);
$date2=$tempto[2]."-".$tempto[0]."-".$tempto[1];
$gw=0;
waiting for early response.