insert record from file field using DFP

using PHP/mySQL have a form to insert items into record.
4 fields of the insert form are file/fields for images.
Using DFP to upload the images from these fields to folder 'uploads'

using the DW insert record server behavior, i want the file name from the file/field to be put into item column as text so that when displaying items i can put the image src path to the image with a recordset.

just tested the insert and the DFP worked correctly and uploaded image file 'cane21_img1.jpg' to folder 'uploads'

how can i get the file name to be inserted as text in the correct column of the item record?

thanks for your help,
Jim balthrop

In the bindings panel within dreamweaver, the file name that is uploaded is stored. You can get various values associated with the upload under the WA Upload Files in Bindings. You should use these values to insert the values you want into your database.

Jimmy,

thanks for your response

i had never used data assist insert record before(had always used dreamweaver insert record)

i tried data assist insert single record and binded the picture fields to the dfp client file name for that file field image upload.

worked like a charm-> the images uploaded to folder 'uploads'
and the file names 'img_1.jpg' 'img_2.jpg' 'img_3.jpg' img_4.jpg' inserted in the proper column 'item_pic1' etc. of the item record.
so on the item display page i used
<img src="uploads/<?php echo $row_rs_itemcat['item_pic1']; ?>" />

WebAssist is the GREATEST!

Great to hear that you got it working. If you have any additional issues, feel free to make a new thread if you run into any additional issues.