Generated form, how to get POST content and insert it in mysql

[Peuplarchie]

Good day all,
I'm working on a thing which lets the member create, edit, delet it's own table and data.

I have a form in a table which list the table data, this form should add a row.
Here is it's code :

$tid = $_GET['id'];
$tname = $_GET['tname'];

$con = mysql_connect($server, $login, $password);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db($db, $con);

$query = "SELECT * FROM $tname";
$resultv = mysql_query($query); 
if (($resultv)||(mysql_errno == 0))
{
  echo "<table width='100%' border=\"1\">\n";
  echo "<tr>";
  echo "<td align='center'><b>Options</b></td>";  
  if (mysql_num_rows($resultv)>0)
  {
          //loop thru the field names to print the correct headers
          $i = 0;
          while ($i < mysql_num_fields($resultv))
          {
       echo "<th>". mysql_field_name($resultv, $i) . "  <a href=\"tableau.php?act=delcol&opt=tableau&tname=".$tname."&cname=".mysql_field_name($resultv, $i)."\" title=\"DELETE COLUMN : ". mysql_field_name($resultv, $i) . "\"><img src=\"Images/stock_delete-column.png\" align=\"bottom\"></a></th>\n";
       
       $i++;
    }
    echo "</tr>";
   
 echo "<tr><form  name=\"formadd\" method=\"post\" action=\"tableau.php?add=row\">\n";
          //loop thru the field names to print the correct headers
          $i = 0;
      echo "<td align='center'><input type=\"submit\" value=\"Ajouter\"></td>";
          while ($i < mysql_num_fields($resultv))
          {
          echo "<td align='center'><input type=\"text\" name=\"". mysql_field_name($resultv, $i) . "\"</td>\n";
          $i++;
          }
echo "</form></tr>\n";  
   
    //display the data
    while ($rowv = mysql_fetch_array($resultv,MYSQL_ASSOC))
    {
      echo "<tr><td><br></td>\n";
      foreach ($rowv as $data)
      {
       if ($data == "") {
        echo "<td align='center'><br></td>\n";
       }else{    
        echo "<td align='center'>". $data . "</td>\n";
       }
      }
    }
  }else{
    echo "<tr><td colspan='" . ($i+1) . "'>No Results found!</td></tr>\n";
  }

echo "</table>";  
}else{
  echo "Error in running query :". mysql_error();
} 

My issue is to receive the data and insert it in the database.
I have know clue how to put the POSTs into variable so I can Insert it in the query..

Can somebody help me ?

Take care !

[NogDog]

Have you started with the manual? Variables From External Sources: HTML Forms (GET and POST)

[Peuplarchie]

Getting closer..

$sql1= 'SHOW TABLES FROM ' .$db .' LIKE '.$tname;
$res1= mysql_query($sql1) OR die('Query 1 error:<br />' .mysql_error());

echo '<table border=1 cellpadding=1 cellspacing=0 width="90%">';
while ( $row= mysql_fetch_row($res1) )
{
    echo '<tr>';
    echo '<td valign="top" align="center">' .$tname. '</td>';
    echo '<td>';
    $sql2= 'SHOW CREATE TABLE ' .$tname;
    $res2= mysql_query($sql2) OR die('Query 2 error:<br />' .mysql_error());
    while ( $table_def= mysql_fetch_row($res2) )
    {
        for ($i=1; $i<count($table_def); $i++)
        {
            echo '<pre>' .$table_def[$i]. '</pre>';
        }
    }
    echo '</tr>';
}
echo '</table>';