Hey guys

I'm guessing this is probably pretty simple for anyone who's not a PHP rookie.

I have my database, and I'd like to be able to create a page with a form, whereby the user can modify the values for that particular record in the database.

I'd imagine I'll use the 'mysql_query' function to call the query based on the ID carried across from the previous page. From there, I'm a little stuck. I'd like this page to have all of the fields from the query (*), and the value currently in the database in the fields, for that particular ID.

I noticed the 'mysql_fetch_field' function, but how do I then have the data for that field and the specified record (in the query) as well?

Thanks for any help you can provide!

bump...

mysql_fetch_array() will allow you to fetch an associative array so you can require the field name for each row.

while(list(field1,field2,..) = mysql_fetch_array())