Hi, when i click the button in the form below, nothing happens...why ?

[jd2007]

 <?php
$db=$_GET[db];
$query2="use $db";
$result2=mysql_query($query2);
$sql = "select * from $_GET[t]";
$result2 = mysql_query($sql);
$num=mysql_num_rows($result2);
$r=0;
$c=0;
echo "<script src='myareaajax.js'></script><form method='get' action='update.php'><table border=1><tr>";
for ($b=1; $b<=$num; $b++)
{
$sql2 = "select * from $_GET[t] where id='$b'";
$result4 = mysql_query($sql2);
while ($record = mysql_fetch_assoc($result4)) {
	while (list($fieldname, $fieldvalue) = each ($record)) {
            $c++;
		echo "<td><input type=text id=$c value=$fieldvalue /></td>";
		$arr[]="$fieldvalue";
            
	}
	echo "</tr>";
	}
	$r++;
}
//print_r($arr."<br /><br />");
$arr=serialize($arr);
echo $arr;
$table=$_GET["t"];
echo "</table>";
echo "<input type='hidden' name='c' value='$c' />";
  echo "<input type='hidden' name='r' value='$r' />";
  echo "<input type='hidden' name='t' value='$t' />";
  echo "<input type='hidden' name='db' value='$db' />";
  echo "
  <input type='button' name='update' value='Update'        onclick=my_area('update.php','db=$db&t=$t&c=$c&r=$r&arr=$arr','3'); />
  </form><br />";?>

 

the my_area function is in myareaajax.js.

 

myareaajax.js:

 

  <!--
   var xmlHttp;
   var stg;
   //var xmlHttp2;

   function my_area(src, variables, stage)
   {
    xmlHttp=GetXmlHttpObject()
    if (xmlHttp==null)
    {
      alert ("Your browser does not support AJAX!");
      return;
     }
    var url=src;
var info=variables;
stg=stage;
    url=url+"?"+info;
    xmlHttp.open("GET",url,true);
    xmlHttp.onreadystatechange=stateChanged;
    xmlHttp.send(null);
   }

function stateChanged() 
   { 
   if (xmlHttp.readyState==4)
   { 
    var myarea="myarea"+stg;
    document.getElementById(myarea).innerHTML=xmlHttp.responseText;
   }
   } 

function GetXmlHttpObject()
{
var xmlHttp=null;
//var xmlHttp2=null;
try
  { 
  // Firefox, Opera 8.0+, Safari
  xmlHttp=new XMLHttpRequest();
  //xmlHttp2=new XMLHttpRequest();
  }
catch (e)
  {
  // Internet Explorer
  try
    {
    xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
    //xmlHttp2=new ActiveXObject("Msxml2.XMLHTTP");
    }
  catch (e)
    {
    xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
    //xmlHttp2=new ActiveXObject("Microsoft.XMLHTTP");
    }
  }
return xmlHttp;
//return xmlHttp2;
}
  //-->

[gerkintrigg]

could you not just replace the button with a submit button?

[jd2007]

when i put submit, the ajax code doesn't execute instead the page changes...i want the ajax code to be executed, why doesn't it execute ?

[slimfat]

change:

echo "
  <input type='button' name='update' value='Update'        onclick=my_area('update.php','db=$db&t=$t&c=$c&r=$r&arr=$arr','3'); />
  </form><br />";?>

to:

echo "
  <input type='submit' name='update' value='Update'        onclick=my_area('update.php','db=$db&t=$t&c=$c&r=$r&arr=$arr','3'); />
  </form><br />";?>