need to move 75,000 images

[jasondavis]

I need to cycle through mysql table that list the name of 25,000 images which are all saved into the

same folder
I then need to break this folder into folders of 2000 images, it need to update the DB table

"friend_user_photo" which stores the image path as image.jpg to rewrite it as foldernumber/image.jpg

for every image listed in the DB.

Every image in the DB has 2 additional images associated with it that are not in the DB
they have thumb and thumb1 added to the begginning of the filename, it will need to move all 3

images for each DB entry so its 75,000 images total.

Any ideas how to accomplish this

[justsomeone]

This sounds straightforward. In pseudo-ese, here is how I would go about accomplishing this.

set counter to 0
set folder to 0
select rows from database
for each row{
if counter == 2001{
counter = 1
}else{
counter += 1
}
if counter == 1{
add 1 to folder
mkdir folder
}
move image."*" to new folder
update row set image to folder."/".image
}

Shouldn't take much to convert the above to PHP. You might want to consider some finessing like formating folder name so that it is zero-padded. This might make it easier to navigate later.