Form generation

[fnbcprog]

I am trying to generate a form composed of multiple text fields that represent the different fields of the database. How would you write a for loop to go through the mysql table, count the number of fields, and assign and print the names to the text fields.

I hope you can help me!😕

[cgraz]

<?

// assign your info to the following variables
$server = "";
$username = "";
$password = "";
$database = "";
$table = "";

mysql_connect($server, $username, $password) or die("couldn't connect");

mysql_select_db($database) or die("couldn't select database");

$query = mysql_query("SELECT * FROM $table");
$num_rows = mysql_num_rows($query);

echo "Number of Rows: " . $num_rows . "<br>";

echo "<form method=post action=process.php>\n";

while ($a_row=mysql_fetch_array($query)) 
  {
         for($i=0; $i < $num_rows; $i++) 
           {
              print $a_row["$i"] . ": <input type=text name='" . $a_row["$i"] . "' value='" . $a_row["$i"] . "'><br>\n";
           }

print "<br>\n";

  }

echo "</form>";

?>

Cgraz