Building an updateable grid...

[rcarr]

Hey gang, I am taking this project to the next level. How many levels are there anyways? :p

Anyways, I'd like to display a "grid" of records. Then the user can update a field or two in each record using form fields. I was hoping to use a checkbox field. I have code working to update a form using PHP/MySQL. I have a table of read-only data that I present. I am just missing how to combine the benefits of both into one page.

Here's my question(s).

1. Once I populate this grid with data, how can I tell which row the user modified?

2. How do I associate the form fields to the specific records?

Thanks gang. I appreciate the help, as always.

[HalfaBee]

You will have to create your <FORM> from the DB setting the name and value.

<INPUT name='fieldname' value='fieldvalue_rowid' type=text >

You will have to do this for every field and row
Nest loops are needed to do this

// sortof code
while( $row = mysql_fetch_assoc() )
foreach( $row as $value => $key )
echo 'input stuuf';

You will obviously have to create a table and all assoc. tags to make it neat.

HalfaBee