| Server IP : 92.204.40.98 / Your IP : 216.73.216.201 Web Server : LiteSpeed System : Linux amster.dnsfors.com 4.18.0-553.111.1.el8_10.x86_64 #1 SMP Sun Mar 8 20:06:07 EDT 2026 x86_64 User : tmksyste ( 2190) PHP Version : 8.3.31 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/tmksyste/domains/tmksystems.in/public_html/applications/ |
Upload File : |
<?php include('connection.php');error_reporting(0);?>
<h3>Marketing Activity Of <?php
$lid=$_GET['id'];
$sql1="select * from leads where lid=$lid";
$result1=mysql_query($sql1)or die(mysql_error());
$row1=mysql_fetch_array($result1);
echo $row1['name_firm'];
?></h3>
<table border="1">
<th>Date</th><th>Mobile<br>Email</th><th>Contact Person<br>Designation<br>Contact Number</th><th>FollowUp Person <br>Details</th><th>Method</th><th>Lead Priority & Status</th><th>Excecutive</th><th>FollowUp Date & Time</th><th>MNRI Status & Date</th><th>Remarks</th>
<?php
if($_GET['id']!=""){$id=$_GET['id'];
$sqlm="select * from marketing_activities where lid='$id' order by date desc";
$resultm=mysql_query($sqlm);
while($rowm=mysql_fetch_array($resultm)){
$eid=$rowm['followup_excecutive'];
$sql12="select * from login where id=$eid";
$result12=mysql_query($sql12)or die(mysql_error());
$row12=mysql_fetch_array($result12);
if(empty($rowm['mnri_date']))
$mnri_date='';
else
$mnri_date=date('d-m-Y',strtotime($rowm['mnri_date']));
?>
<tr><td><?php echo date('d-m-Y',strtotime($rowm['date']));?></td>
<td width="10%"><?php echo $rowm['whatsapp']."<br>".$rowm['email'];?></td>
<td><?php echo $rowm['contact_name1']."<br>".$rowm['designation1']."<br>".$rowm['number1'];?></td>
<td><?php echo $rowm['followup_person_name']."<br>".$rowm['followup_designation']."<br>".$rowm['followup_number'];?></td>
<td><?php echo $rowm['method'];?></td>
<td><?php echo $rowm['lead_priority']." , ".$rowm['lead_status'];?></td>
<td><?php echo $row12['Name'];?></td>
<td><?php echo date('d-m-Y',strtotime($rowm['follow_date']))."<br>".$rowm['follow_time'];?></td>
<td><?php echo $rowm['mnri_status']."<br>".$mnri_date;?></td>
<td><?php echo $rowm['remarks'];?></td>
</tr>
<?php }}?>
</table>