i m designing a CRM for real Estate company. dis is d code i hve used to log d details of client :-

<?php
session_start();

if($_SESSION['Name']=='')
{
echo "<script>window.location='login.html';</script>";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>CALL LOG DETAILS</title>

</head>
<?php
include('connection.php');
/*$username="root";
$password="";
$database="_relocateeasily";
mysql_connect(localhost,$username,$password);

mysql_select_db($database) or die("Unable to select database");*/
$z=array();

if($_POST['submit']==AllRequirementsTaken)
{

$bor=$_POST['choices'];
$Locality=serialize($_POST['Location']);
if($_POST['Location']!=0)
{
foreach($_POST['Location'] as $zonec)
{
$query="select ZoneName from zone1 where LocationName='$zonec'";
$result=mysql_query($query);
$num=mysql_numrows($result);
$i=0;
    if($num!=0)
    {
        while($i<$num) {
        $zone1=mysql_result($result,$i,"ZoneName");
        $i++;
    }
    }
global $z;
array_push($z,$zone1);
}

$z = array_unique($z);
$zone=serialize($z);
}
$SalesCoordinator=$_POST['coordinator'];
$SalesExecutive=$_POST['SalesExecutive'];
$OtherPreferences=$_POST['OtherPreferences'];
$BHK=serialize($_POST['BHK']);
$FoodType=$_POST['choice3'];
$Parking=serialize($_POST['choice5']);
$ExpectedMove_inDate=$_POST['ExpectedMove_inDate'];
$Budget=$_POST['Budget'];
$MaxBudget=$_POST['MaxBudget'];
$ResudenceType=serialize($_POST['choice6']);
$ClientType=$_POST['choice2'];
$Furnishing=$_POST['choice4'];
$NextContactDate=$_POST['NextContactDate'];
$NextContactTime=$_POST['NextContactTime'];
$TADate=$_POST['TADate'];
$TATime=$_POST['TATime'];
$NoOfPeople=$_POST['NoOfPeople'];
$callnotes=$_POST['CallNotes'];
$Name=$_POST['Name'];   
$Address=$_POST['Address'];
$Company=$_POST['Company'];
$CompanyLocality=$_POST['CompanyLocality'];
$MobileNo=$_POST['MobileNo'];
$OtherNo=$_POST['OtherNo'];
$EmailID=$_POST['EmailID'];
$MarketingStrategy=$_POST['choice7'];
$CameVia=$_POST['choice8'];
$CameOn=$_POST['CameOn'];
$Notes=$_POST['Notes'];



    $query1="INSERT INTO clientrequirement (Buy,Locality,Zone,SalesCoordinator,SalesExecutive,OtherPreferences,BHK,FoodType, Parking,ExpectedMove_inDate,Budget,MaxBudget,ResidenceType,ClientType,Furnishing,NextContactDate,NextContactTime,TADate,TATime,NoOfPeople,CallNotes,status) VALUES ('$bor','$Locality','$zone', '$SalesCoordinator', '$SalesExecutive', '$OtherPreferences', '$BHK', '$FoodType', '$Parking', '$ExpectedMove_inDate', '$Budget','$MaxBudget', '$ResudenceType', '$ClientType', '$Furnishing', '$NextContactDate', '$NextContactTime', '$TADate', '$TATime','$NoOfPeople', '$callnotes','1')";
        $sql=mysql_query($query1);


if(!($sql))
{echo "not able ";}


$query2="INSERT INTO clientdetails ( Name,Address, Company, CompanyLocality, MobileNo, OtherNo, EmailID, MarketingStrategy, CameVia,CameOn,Notes,status) VALUES ('$Name','$Address','$Company','$CompanyLocality','$MobileNo','$OtherNo','$EmailID', '$MarketingStrategy','$CameVia','$CameOn','$Notes','1')";
mysql_query($query2);
$query="SELECT MAX(ClientID) as id FROM clientdetails";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$id = $row['id'];
$query3="insert into calllog(ClientID,nextcalldate,nextcalltime,callnotes,status) values('$id','$NextContactDate', '$NextContactTime', '$callnotes','1')";
mysql_query($query3);
echo "<script>window.location='index.php'</script>";
}
if($_POST['submit']==YetRequirementsTaken)
{
$bor=$_POST['choices'];
$Locality=serialize($_POST['Location']);
if($_POST['Location']!=0)
{
foreach($_POST['Location'] as $zonec)
{
$query="select ZoneName from zone1 where LocationName='$zonec'";
$result=mysql_query($query);
$num=mysql_numrows($result);
$i=0;
    if($num!=0)
    {
        while($i<$num) {
        $zone1=mysql_result($result,$i,"ZoneName");
        $i++;
    }
    }
global $z;
array_push($z,$zone1);
}

$z = array_unique($z);
$zone=serialize($z);
}
$SalesCoordinator=$_POST['coordinator'];
$SalesExecutive=$_POST['SalesExecutive'];
$OtherPreferences=$_POST['OtherPreferences'];
$BHK=serialize($_POST['BHK']);
$FoodType=$_POST['choice3'];
$Parking=serialize($_POST['choice5']);
$ExpectedMove_inDate=$_POST['ExpectedMove_inDate'];
$Budget=$_POST['Budget'];
$MaxBudget=$_POST['MaxBudget'];
$ResudenceType=$_POST['choice6'];
$ClientType=$_POST['choice2'];
$Furnishing=$_POST['choice4'];
$NextContactDate=$_POST['NextContactDate'];
$NextContactTime=$_POST['NextContactTime'];
$TADate=$_POST['TADate'];
$TATime=$_POST['TATime'];
$NoOfPeople=$_POST['NoOfPeople'];
$callnotes=$_POST['CallNotes'];
$Name=$_POST['Name'];   
$Address=$_POST['Address'];
$Company=$_POST['Company'];
$CompanyLocality=$_POST['CompanyLocality'];
$MobileNo=$_POST['MobileNo'];
$OtherNo=$_POST['OtherNo'];
$EmailID=$_POST['EmailID'];
$MarketingStrategy=$_POST['choice7'];
$CameVia=$_POST['choice8'];
$CameOn=$_POST['CameOn'];
$Notes=$_POST['Notes'];
 $query1="INSERT INTO clientrequirement (Buy,Locality,Zone,SalesCoordinator,SalesExecutive,OtherPreferences,BHK,FoodType, Parking,ExpectedMove_inDate,Budget,MaxBudget,ResidenceType,ClientType,Furnishing,NextContactDate,NextContactTime,TADate,TATime,NoOfPeople,CallNotes,status) VALUES ('$bor','$Locality','$zone', '$SalesCoordinator', '$SalesExecutive', '$OtherPreferences', '$BHK', '$FoodType', '$Parking', '$ExpectedMove_inDate', '$Budget','$MaxBudget', '$ResudenceType', '$ClientType', '$Furnishing', '$NextContactDate', '$NextContactTime', '$TADate', '$TATime','$NoOfPeople', '$callnotes','0')";
        $sql=mysql_query($query1);


$query2="INSERT INTO clientdetails ( Name,Address, Company, CompanyLocality, MobileNo, OtherNo, EmailID, MarketingStrategy, CameVia,CameOn,Notes,status) VALUES ('$Name','$Address','$Company','$CompanyLocality','$MobileNo','$OtherNo','$EmailID', '$MarketingStrategy','$CameVia','$CameOn','$Notes','0')";
mysql_query($query2);
$query="SELECT MAX(ClientID) as id FROM clientdetails";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$id = $row['id'];
$query3="insert into calllog(ClientID,nextcalldate,nextcalltime,callnotes,status) values('$id','$NextContactDate', '$NextContactTime', '$callnotes','1')";
mysql_query($query3);
 echo "<script>window.location='index.php'</script>";

}
if($_POST['submit']==DUMP)
{
$bor=$_POST['choices'];
$Locality=serialize($_POST['Location']);
if($_POST['Location']!=0)
{
foreach($_POST['Location'] as $zonec)
{
$query="select ZoneName from zone1 where LocationName='$zonec'";
$result=mysql_query($query);
$num=mysql_numrows($result);
$i=0;
    if($num!=0)
    {
        while($i<$num) {
        $zone1=mysql_result($result,$i,"ZoneName");
        $i++;
    }
    }
global $z;
array_push($z,$zone1);
}

$z = array_unique($z);
$zone=serialize($z);
}
$DumpReason=$_POST['dump'];
$DumpDetails=$_POST['DumpDetails'];
$SalesCoordinator=$_POST['coordinator'];
$SalesExecutive=$_POST['SalesExecutive'];
$OtherPreferences=$_POST['OtherPreferences'];
$BHK=serialize($_POST['BHK']);
$FoodType=$_POST['choice3'];
$Parking=serialize($_POST['choice5']);
$ExpectedMove_inDate=$_POST['ExpectedMove_inDate'];
$Budget=$_POST['Budget'];
$MaxBudget=$_POST['MaxBudget'];
$ResudenceType=$_POST['choice6'];
$ClientType=$_POST['choice2'];
$Furnishing=$_POST['choice4'];
$NextContactDate=$_POST['NextContactDate'];
$NextContactTime=$_POST['NextContactTime'];
$TADate=$_POST['TADate'];
$TATime=$_POST['TATime'];
$NoOfPeople=$_POST['NoOfPeople'];
$callnotes=$_POST['CallNotes'];
$Name=$_POST['Name'];   
$Address=$_POST['Address'];
$Company=$_POST['Company'];
$CompanyLocality=$_POST['CompanyLocality'];
$MobileNo=$_POST['MobileNo'];
$OtherNo=$_POST['OtherNo'];
$EmailID=$_POST['EmailID'];
$MarketingStrategy=$_POST['choice7'];
$CameVia=$_POST['choice8'];
$CameOn=$_POST['CameOn'];
$Notes=$_POST['Notes'];
 $query1="INSERT INTO clientrequirement (Buy,Locality,Zone,SalesCoordinator,SalesExecutive,OtherPreferences,BHK,FoodType, Parking,ExpectedMove_inDate,Budget,MaxBudget,ResidenceType,ClientType,Furnishing,NextContactDate,NextContactTime,TADate,TATime,NoOfPeople,CallNotes,status,DumpReason,DumpDetails,DumpDate) VALUES ('$bor','$Locality','$zone', '$SalesCoordinator', '$SalesExecutive', '$OtherPreferences', '$BHK', '$FoodType', '$Parking', '$ExpectedMove_inDate', '$Budget','$MaxBudget', '$ResudenceType', '$ClientType', '$Furnishing', '$NextContactDate', '$NextContactTime', '$TADate', '$TATime','$NoOfPeople', '$callnotes','4','$DumpReason','$DumpDetails','$CameOn')";
        $sql=mysql_query($query1);
$query2="INSERT INTO clientdetails ( Name,Address, Company, CompanyLocality, MobileNo, OtherNo, EmailID, MarketingStrategy, CameVia,CameOn,Notes,status) VALUES ('$Name','$Address','$Company','$CompanyLocality','$MobileNo','$OtherNo','$EmailID', '$MarketingStrategy','$CameVia','$CameOn','$Notes','4')";
mysql_query($query2);
$query="SELECT MAX(ClientID) as id FROM clientdetails";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$id = $row['id'];
$query3="insert into calllog(ClientID,nextcalldate,nextcalltime,callnotes,status) values('$id','$NextContactDate', '$NextContactTime', '$callnotes','1')";
mysql_query($query3);

}

if($_POST['submit']==CLEAR)
{
}
?>
<body onload="count()">
<form method="GET" action="" name="form" >
<link href="styles2.css" rel="stylesheet" type="text/css" media="screen" />
<link rel="stylesheet" type="text/css" href="view1.css" media="all">
<div style="position:absolute; right:70px; top:70px">
<table ><tr>
<td align="right" width="680"><div style="color:#CC0000;">Select The Field To sort:</div></td><td ><select  id="select2" name="s" size="1" style="width:150px;">
<option selected="selected"></option>
<OPTION value="Name">Name</OPTION>
<OPTION value="MobileNo">Mobile No</OPTION>
<OPTION value="SalesExecutive">Sales Executive</OPTION>
<OPTION value="CallNotes"> Call Notes</OPTION>
</select>
<a href="javascript:;" onclick="sort1()">GO</a></td><td></td><td>
<a href="signout.php">SIGNOUT</a></td></tr></table>
<input type="hidden" value="ASC"  id="order" />
</div>

        <div id="menu5">
        <ul>
        <table><tr><td ><li><a href="client1.php">NEW CLIENT</a></li></td>
        <td><li><a href="TakeRequirement.php">TReq</a></li></td>
       <td><li><a href="calllog.php">CLIENT LOG</a></li></td>
        <td><li><a href="appointmentlist.php">APPT</a></li></td>
        <td><li><a href="dumplist.php">DUMP LIst</a></li></td>
        <td><li><a href="postdeal2.php">POST DEAL</a></li></td>
      <td><li><a href="reports.php">REPORTS</a></li></td>
       <td><li><a href="s1.php">SE</a></li></td></tr>
        </table>
        </ul>
        </div>
<div id="name">
<?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 "<div id=\"count1\"></div>";
print"<div id=\"content\" style=\"position:absolute;left:5px;top:100px;margin:20px;width:800px;height:80px;z-index:14;\" align=\"left\"><br />"; 
print "<h2 align=center>CLIENT LOG DETAILS</h2>";
print "<table border=0 align=center><tr bgcolor='#8B8B83'><th><div  style=\"width:150px\">NAME </div></th><th>MOBILE NO  </th><th><div style=\"width:100px\">SE</div></th><th><div style=\"width:80px\">NC DATE </div> </th><th>NC TIME</th><th>CALL NOTES </th></tr></tr>";
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 "<tr bgcolor='#CDCDC1' align=center><td><a href=\"details.php?id=$id\" >$name</td><td align=center><a href=\"javascript:;\" onclick=\"window.open('todaysappt.php?id=$id','mywindow','width=350,height=200,left=100,top=100,screenX=100,screenY=300') \">$mobileno</a></td><td>$se</td><td>";
if($nd>date("Y-m-d"))
{
print "<input type=\"text\" size =\"8\" id=\"$d1\" name=\"NextContactDate\" value=\"$ncd\"/>";
}
if($nd<date("Y-m-d"))
{
print "<input type=\"text\" class=\"box\" size =\"8\" id=\"$d1\" name=\"NextContactDate\" value=\"$ncd\"/>";
}
if($nd==date("Y-m-d"))
{
print "<input type=\"text\" class=\"box1\" size =\"8\" id=\"$d1\" name=\"NextContactDate\" value=\"$ncd\"/>";
}
print "</td><td><input type=\"text\" size =\"6\" id=\"$t1\" name=\"NextContactTime\" value=\"$time\"/><td><input type=\"text\" id=\"$n\"      name=\"CallNotes\" size=\"30\" value=\"$c\"/></td><td><a href=\"javascript:;\" onclick=\"updatecalllog($id,'$n','$d1','$t1')\">update</td></tr>";
   $i++;

 }


print "</table>";
print "</div>";
}
?>
</div>
<?php
$query="SELECT ClientID,Name,SalesExecutive,ApptNotes from todaysappt";
$result = mysql_query($query);
$d = mysql_num_rows($result);
if($d>=1)
{
$i=0;
print "<div id=\"count1\"></div>";
print"<div id=\"content\" style=\"position:absolute;left:800px;top:100px;margin:20px;width:800px;height:80px;z-index:14;\" align=\"left\"><br />"; 
print "<h2>TODAYS APPT DETAILS</h2>";
print "<table border=0 align=center><tr bgcolor='#8B8B83'><th><div  style=\"width:150px\">NAME </div></th><th><div style=\"width:100px\">SE</div></th><th><div style=\"width:150px\">APPT NOTES</div> </th></tr>";
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");
?>
<tr bgcolor='#CDCDC1' align=center><td><a href="details.php?id=<?=$id?>"><?=$name?></a></td><td><?=$se?></td><td><input type="text"name="ApptNotes" value="<?=$notes?>" onchange="updateappt('APPtNotes',this.value,<?=$id?>)" /></td><td><a href='deletetodaysappt.php?id=<?=$id?>'>delete</a></td></tr>
<?php
   $i++;

 }


print "</table>";
print "</div>";
}
?>
</form>
</body>
</html>
<script type="text/javascript">
function updatecalllog(id,notes,date,time)
{
var val = document.getElementById(notes).value;
var d = document.getElementById(date).value;
var t = document.getElementById(time).value;

var url="callnotesupdate.php?id="+id+"&cn="+val+"&date1="+d+"&time1="+t+"&timeid="+(Math.random()*100000);

if(window.XMLHttpRequest)
 {


    req=new XMLHttpRequest();
    req.open("GET",url,true);
    req.send(null);
 }
 else if(window.ActiveXObject)
 {
    req=new ActiveXObject("MSXML2.XMLHTTP.3.0");
    req.open("GET",url,true);
    req.send(null);
  }
}
function sort1()
{
var val=document.getElementById("select2").value;
var order=document.getElementById("order");
 var url="sort.php?field="+val+"&order="+order.value+"&timeid="+(Math.random()*100000);
if(order.value=='ASC')
{
  order.value='DESC';
  }
  else if(order.value=='DESC')
  {
  order.value='ASC';
  }
if(window.XMLHttpRequest)
 {


    req=new XMLHttpRequest();
    req.open("GET",url,true);
    req.send(null);
 }
 else if(window.ActiveXObject)
 {
    req=new ActiveXObject("MSXML2.XMLHTTP.3.0");
    req.open("GET",url,true);
    req.send(null);
  }
  req.onreadystatechange = function ()
  {
if(req.readyState==4)
{
      document.getElementById('name').innerHTML=req.responseText;
}
}
}
function count()
{
var url1="count.php?timeid="+(Math.random()*100000);

if(window.XMLHttpRequest)
 {


    req=new XMLHttpRequest();
    req.open("GET",url1,true);
    req.send(null);
 }
 else if(window.ActiveXObject)
 {
    req=new ActiveXObject("MSXML2.XMLHTTP.3.0");
    req.open("GET",url1,true);
    req.send(null);
  }
  req.onreadystatechange = function ()
  {
if(req.readyState==4)
{
      document.getElementById('count1').innerHTML=req.responseText;
}
}
}
function updateappt(name,value,id)
{
var url="todaysapptupdate.php?id="+id+"&name="+name+"&value="+value+"&timeid="+(Math.random()*100000);
if(window.XMLHttpRequest)
 {
    req=new XMLHttpRequest();
    req.open("GET",url,true);
    req.send(null);
 }
 else if(window.ActiveXObject)
 {
    req=new ActiveXObject("MSXML2.XMLHTTP.3.0");
    req.open("GET",url,true);
    req.send(null);
  }

}
</script>

now My Mysql database consist of d fileds such as:

ClientID,Locality,Zone,CRA,GroundFloor,TopFloor,Amenities,OtherPreferences,BHK,MINBudget,MaxBudget,Vastu,NextContactDate,NextContactTime,MinSqft,CallNotes,status,DumpDetails,DumpReason,DumpDate.                           

In d above code, d fields r different and query is embedded wid old db fields.

I want to edit dis fields correctly wid d above said fields

i hve tried a lot bt m getting error.

so plz reply n try to correct d code

Thanx :)

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.