insert on update

[rawky1976]

Hello

 

I'm using DW to upload a file and insert a record into a mySQL db.

 

My documents table has an extension field for the file extension.

 

I understand the associative array automatically stores this in $HTTP_POST_FILES['fupload']['type']

 

What code would I use in my insert statement: -

 

$insertSQL = sprintf("INSERT INTO document (document_name, document_extension, keywords, about, category, format, submitter) VALUES (%s, %s, %s, %s, %s, %s, %s)",

 

where document_extension is currently: -

 

GetSQLValueString($_POST['documentPath'], "text"),

 

where documentPath is the name of my file upload filed on the form?

 

I know I have to alter this to include some php code but what is the correct syntax?

 

Thanks, Mark