include("top.inc");
include("left.inc");
include("detectuser.php");
function format_date_local($mySql_date)
{
if(strstr("/",$mySql_date))
$date_array=explode("/",$mySql_date);
else
$date_array=explode("-",$mySql_date);
$date_now=date("l, F d, Y",mktime(date("h"),date("i"),date("s"),$date_array[1],$date_array[2],$date_array[0]));
return $date_now;
}
function getFacingSlips()
{
$sql="select * from mailing_slip where memberid=$_COOKIE[u_id] order by doc desc";
$res=mysql_query($sql);
$out="";
return $out;
}
$sql="select * from memberdetails where memberid=$_COOKIE[u_id]";
$res=mysql_query($sql);
$row=mysql_fetch_array($res);
$comp=$row[companyname];
$nm=$_SESSION[mailing_name];
$crid=$_SESSION[crid];
if($_POST[dl])
{
$sql="Delete from mailing_slip where sno=$_POST[lstslip]";
mysql_query($sql);
$msg="Deleted Successfully";
print"";
}
else
{
if($_POST[lstslip])
{
$sql="select * from mailing_slip where sno=$_POST[lstslip]";
$res=mysql_query($sql);
$row=mysql_fetch_array($res);
$nm=$row[mailingname];
$crid=$row[CRID];
$route1=$row[routepart1];
$route2=$row[routepart2];
$customer=$row[totalcustomers];
$dt=$row[dateofmailing];
$dt_arr=explode("-",$dt);
$yr=$dt_arr[0];
$mo=$dt_arr[1];
$da=$dt_arr[2];
}
}
?>
 |
 |
|
