hey all, I am trying to create a form that does the following: [ i have most of it
done]
1. queries the db and gets the values of the ID, TITLE, and FILENAME columns in a table
2. creates a form with the TITLE <INPUT type="text"> with the filename echoed if it
exists
3. on submission the form update the FILENAME field.
I have completed up to step 2. I am not sure how i should name the fields to make this
easiest. The purpose of the form is so i can insert a value for a picture that
corresponds to each TITLE. here's some of my my code.
this builds the form input fields.
while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$title = $row['title'];
$filename = $row['filename'];
$form .= "$title <input type=\"text\" name=\"$id\" size=15 maxlength=20";
if ($filename) {
$form .= " VALUE=\"$filename\"";
}
$form .= "><br>";
// end while
}
this is the INSERT that does not work yet