Using arrays in an HTML table

unmash

Hi All;

I was wondering if there is anyone out there that can give me a few pointers to a olution for my conundrum.

I have to display the contents of all the fields in a particular table and then give the user the ability to change it.

I wrote a for-next loop that runs thru all the fields in the table and returns them to text boxes defined in a table.

I did not harcode the values in my table, but have assigned them as follows:
$ResultOfDBQuery=mysql_list_fields($DB,$con)
for ($i=0;$i<size_of_table;Si++)
{
<body>
<form action=somefield.php method="post>
<table>
<tr>
<td><input=text <?echo ResultsOfDBquery[$i]?> value="<?echo ResultofDBQuery[$i]?>"</td>
}
<input="submit"......>
</form>
</table>

This works fine and prints out the correct values in the correct fields BUT, when I call somefield.php, I would've expected that I could now access the values in the table with $<?echo ResultsOfDBQuery[$i]?> (i.e with a $ sign before the "name" variable used in the table used. I obviously have a new loop for $i in somefield.php).

The reality of the matter is, that $ResultsOfDBQuery[$i] (or any combination thereof) is completely empty. It seems like
none of the data is passed through to the new php module.

Does anyone have any idea why my data isn't being passed though or how I can pass the info thorough short of hardcoding a seperate <td><input=text name=??? ></td>
for each field.

I did try <td><input=text name=field[]></td>
but that didn't work either

I'm in desperate need of help!!!!!

Thanking you all in advance

Uriel

}

Anon

name="<?echo ResultsOfDBquery[$i]?>"

You have to give form fields names to access them after a post. In your example your text field has no name

<td><input=text <?echo ResultsOfDBquery[$i]?> value="<?echo ResultofDBQuery[$i]?>"</td>

unmash

Sorry about that. I do have the name field between my <td> brackets and that is why I'm confused.

I've attached a "new" version below.

$ResultOfDBQuery=mysql_list_fields($DB,$con)
for ($i=0;$i<size_of_table;Si++)
{
<body>
<form action=somefield.php method="post>
<table>
<tr>
<td><input=text name=<?echo ResultsOfDBquery[$i]?> value="<?echo ResultofDBQuery[$i]?>"</td>
}
<input="submit"......>
</form>
</table>

THanks
Uriel

Thanks

Uriel

unmash

Oops...I made a mistake in my previous post.
Attached below is the cut and paste version of the code that doesnt pass the name variable from my table to my new form.

$database_fields=mysql_list_fields($db, $table);
$number_fields=mysql_num_fields($database_fields);
if ($number_fields)
{
for($index=0;$index<$number_fields;$index+=3)
{?>

				       <head>

</head> <body>
<form action="xxxx.php" method="post">
<table border=1>
<tr>
<td> <input type=text name=<?echo trim(mysql_field_name($database_fields,$index)); ?> maxlength=75 width=75 value ="<? echo $row[$index]; ?> "></td>
</tr>
} //close $index loop

?> <td align=center colspan =5 ><input type = "submit" name=idsubmit value="Submit" > </td>
</form>
</body>

In my xxxx.php module when I try to reference any variable with:

$(mysql_field_name($database_fields,$index)

(I call the same code for the loops,queries etc on both forms) all it does is print '$id' or '$previous' and NOT the value that should've been sent across with the <td>name=id</td> (when the mysql_field_name(xxx,xxxx)=id)

Any suggestions???

Thanks

Uriel