[Resolved] grabbing a variable and entering in mysql

[chaza]

I have this script which uploads a jpeg into a folder and enters some data into a mysql table.
When/if it has uploaded succesfully it requires this script, which takes all the files in the folder and renames them then resizes them.

My problem is that I want to get the name of the renamed file and enter it in to the appropriate row in the database.

1. how do I get the name?

2. how do I find what row to put it in?
   [/list=1]

[chaza]

problem solved.

[kellog]

Not sure if you need to have the name, but a cleaner way of doign this is to add a row to the database, then name the file the unique id of that row, such as 21.jpg.

If this is resolved, mark this topic as resolved.

[chaza]

how do you do that?

[kellog]

So, the way i did it was to first check to see fi the uploaded file was a jpeg, using getimagesize(). If it was, I'd add a row into the database with the user id of who uploaded it, and some other info. Then, after the row is made, i use mysql_insert_id to get the unique id of that row. Now, just change the name of the uploaded file to returned #.jpg

Originally posted by chaza
how do you do that?

[chaza]

Actually thanks,

I meant how do you mark the subject resolved!

I got my problem solved satisfactarily (is that how you spell it?)

[kellog]

Should be a botton on the top of this page to do that.

Originally posted by chaza
Actually thanks,

I meant how do you mark the subject resolved!

I got my problem solved satisfactarily (is that how you spell it?)