here is my code sorry if it is too long. I still got the same 'click' problem
<?php
include("connection.php");
$numLigne = 0;
$nbCol = mysql_num_fields(...);
// get the number of lines in the db
// see if the user want to sort or not
if(isset($_REQUEST['tri']) && !empty($_REQUEST['tri']))
{
$requete = mysql_query ("SELECT * FROM ... ORDER BY tablename.".$_REQUEST['tri']."");
}
else
{
$requete = mysql_query("SELECT * FROM ...");
}
$nbCol = mysql_num_fields(...);
function addNew_row()
{...}
//add a new row at the end of the table
function getLastID()
{...}
//return the last inserted id
function updateTable($arg1,$arg2,$arg3...)
{...}
// update the table with the values sent as parameters
function removerRow()
{...}
//reomve the last row
function get_tHeader($requete,$nbCol)
{
$tHeader = mysql_list_fields("bd","table");
echo "<tr> \n";
for($i = 0; $i < $nbCol; $i++)
{
echo "<th><a href= index.php?tri=".mysql_field_name($tHeader,$i).">".mysql_field_name($tHeader,$i)."</a></th>";
}
echo "<th> </th><th> </th>";
echo "</tr> \n";
}
// create the tabl header based on the table's field in the the db
// this display the bdContent
function getPays($requete,$nbCol)
{
if(isset($_REQUEST['changer']))
{
//if the user want to modify a given row of the table
// displays the content of that row in input text fields
while($ligne = mysql_fetch_row($requete))
{
echo "<tr> \n";
for($i = 0; $i < $nbCol; $i++)
{
if($ligne[0] == $_REQUEST['changer'])
{
if($i != 0)
{
if($ligne[$i] == null)
{
echo "<td><input type ='text' size = '10' name = ".$i." value = ".$ligne[$i]."></td>";
}
else
{
echo "<td><input type ='text' size = '10' name = ".$i." value = ".$ligne[$i]."></td>";
}
}
else
{
echo "<td><input type ='hidden' name = ".$i." value = ".$ligne[$i].">".$ligne[$i]."</td>";
}
}
else
{
if($ligne[$i] == null)
{
echo "<td> </td>";
}
else
{
echo "<td>".$ligne[$i]."</td>";
}
}
}
echo "<td>\n";
echo "<a href = index.php?changer=".$ligne[0]."> Changer </a>";
echo "</td>\n ";
echo "<td><input type = 'submit' value = 'Appliquer' name = 'Appliquer'></td>\n ";
echo "</tr> \n";
}
}
else
{
// else just displays the content in table
while($ligne = mysql_fetch_row($requete))
{
echo "<tr> \n";
for($i = 0; $i < $nbCol; $i++)
{
if($ligne[$i] == null)
{
echo "<td> </td>";
}
else
{
echo "<td>".$ligne[$i]."</td>";
}
}
echo "<td>\n";
echo "<a href = index.php?changer=".$ligne[0]."> Changer </a>";
echo "</td>\n ";
echo "<td><input type = 'submit' value = 'Appliquer' name = 'Appliquer'></td>\n ";
echo "</tr> \n";
}
}
}
// verify if the users want to apply changes
if(isset($_POST['Appliquer']))
{
if(isset($_POST[0]))
{
updateTable($_POST[0],...,$_POST[n]);
//$_POST[n] correspond to the n input text value
}
}
//verify what action to be done
if(isset($_REQUEST['action']))
{
switch($_REQUEST['action'])
{
//add a new row
case 'ajouter' : addNew_row();
$_REQUEST['action'] = null;
break;
//remove the last row
case 'supprimer' : removerRow();
$_REQUEST['action'] = null;
break;
default : break;
}
}
?>
<html>
<head>...
</head>
<body>
<table ...>
(...)
<td >
<form method= "post" action= "<?php echo $_SERVER['PHP_SELF'];?>">
<table width = "800px" border = "0" cellpadding = "3px"cellspasing = "2px">
<?php
get_tHeader($requete,$nbCol);
getPays($requete,$nbCol);
?>
</table>
(...)
<td align = "left">
<a href = "index.php?action=ajouter">Ajouter une Nouvelle ligne</a> |
<a href = "index.php?action=supprimer">Supprimer derniere ligne</a>
(...)
</form>
(...)
</body>
<html>