how do rename a file and insert it's location into a database?

[beloved__one]

I've figured out how to upload an image (thank goodness) but now I want that same form that uploads the file to rename the image file to a unique name as well as input into a row in a database the location of the image file. To be more specific, I've got a whole form with like 5 fields for a user to input info and then the last field the user inputs the location of a file they will be uploading from their computer. Then when the user hit's "submit" the form would need to upload the file, rename it to a unique name, and then input all the information from that form into a database including the location of the image just uploaded.

[kellog]

To rename the file, you can use Move_Uploaded_File. The best way to do this is to make a table in your database to store the photo info in. Include a column in this table that is an auto incrementing unique id. When the photo gets uploaded, first thing, add a row into the database with info about the photo, such as width, height, whatever. Use Mysql_Insert_ID to return the unique id of that column. Then just move the uploaded file (rename) it to "returned unique id.jpg"