Database updated help

[ded]

A form I created allows the user to update some information.  Part of that information is a flyer.  The problem I am having is this:  If the records already has a flyer and the person editing the information changes something and presses submit without loading another file, the file field within that record is cleared instead of leaving the original there.

 

I hope I explained that good enough.

 

editinfo.php

echo "<tr><td align=right valign=top>Flyer:</td><td align=left><input name=\"filename\" type=\"file\">";
echo "<br>Current File: " . substr($row['filename'], 13);

 

postinfo.php

if($_FILES['filename']['error'] != 4) {
$uploaddir = '../../../flyers/';
$uploadfile = $uploaddir . basename($_FILES['filename']['name']);
echo '<pre>';
if (move_uploaded_file($_FILES['filename']['tmp_name'], $uploadfile)) {
echo "File is valid, and was successfully uploaded.\n";
} else {
echo "Possible file upload attack!\n";
}
print "</pre>";
}

 

Regards,

DED

 

[w3evolutions]

There is a few ways you can do this. You can save the original flyer value and check to see if they have uploaded a new one, if not then send the original back so that field still gets updated but either with the original value or a new one. Or you can use mysql INSERT....ON DUPLICATE KEY. http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html.