CRM designing changing Fields

[ashvyas]

Select The Field To sort:NameMobile NoSales Executive Call NotesGO
SIGNOUT

• NEW CLIENT
• TReq
• CLIENT LOG
• APPT
• DUMP LIst
• POST DEAL
• REPORTS
• SE

<?php
$query="SELECT DATE_FORMAT(c.nextcalldate,'%d-%b-%y') as ncdate,c1.ClientId,c1.Name,c1.MobileNo,c2.SalesExecutive,c.nextcalltime,c.nextcalldate,c.callnotes,c2.SalesCoordinator,c.status FROM clientdetails AS c1 INNER JOIN clientrequirement AS c2 inner join calllog as c WHERE c1.ClientID = c2.ClientID and c1.ClientID = c.ClientID and c1.status=1 and c2.status=1 and c1.status=c2.status and c.status=1 and c.status=c2.status ORDER BY c.nextcalldate ,c.nextcalltime";
$result = mysql_query($query);
$d = mysql_num_rows($result);
if($d>=1)
{
$i=0;
print "";
print"
";
print "CLIENT LOG DETAILS";
print "NAME MOBILE NO SENC DATE NC TIMECALL NOTES ";
while($i<$d)
{
$id=mysql_result($result,$i,"ClientID");
$name=mysql_result($result,$i,"Name");
$mobileno=mysql_result($result,$i,"MobileNo");
$sc=mysql_result($result,$i,"SalesCoordinator");
$se=mysql_result($result,$i,"SalesExecutive");
$nd=mysql_result($result,$i,"nextcalldate");
$ncd=mysql_result($result,$i,"ncdate");
$nt=mysql_result($result,$i,"nextcalltime");
$c=mysql_result($result,$i,"callnotes");
$time=date("g:i a", strtotime("$nt"));
$n="notes".$i;
$d1="date".$i;
$t1="time".$i;
$e="executive".$i;
print "$name$mobileno$se";
if($nd>date("Y-m-d"))
{
print "";
}
if($nd";
}
if($nd==date("Y-m-d"))
{
print "";
}
print "update";
$i++;

}

print "";
print "";
}
?>

<?php
$query="SELECT ClientID,Name,SalesExecutive,ApptNotes from todaysappt";
$result = mysql_query($query);
$d = mysql_num_rows($result);
if($d>=1)
{
$i=0;
print "";
print"
";
print "TODAYS APPT DETAILS";
print "NAME SEAPPT NOTES ";
while($i<$d)
{
$id=mysql_result($result,$i,"ClientID");
$name=mysql_result($result,$i,"Name");
$se=mysql_result($result,$i,"SalesExecutive");
$notes=mysql_result($result,$i,"ApptNotes");
?>
<?=$name?><?=$se?>delete
<?php
$i++;

}

print "";
print "";
}
?>

[sourcebits]

Just print the sql string line of insert , update each. You will be able to know where the error is, and you may refer jquery.com ajax post methods to make your ajax work easy.