Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001051

[PHP-DB] dynamic input tyep text updates From: olinux (olnx <email protected>)
Date: 05/07/01

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

_________________________________________________________
Do You Yahoo!?
Get your free  <email protected> address at http://mail.yahoo.com