best way to update image extension in database?

[phpnoobie9]

I have about 100 images in mysql that has an md5 name and are jpgs. I want to change the jpg to gif. What's the best way to do this?

SELECT image FROM mytable....then I'm lost.

[soycharliente]

Do you have a list of each image? You could run a for loop with PHP to loop through the list of images and say something like:

 

UPDATE `table` SET `image`='MD5($imagegif)' WHERE `image`='MD5($imagejpg)' 

[phpnoobie9]

Alright I ran a loop with the list of image names.

 

So....I should take those and...somehow put all of them in the $imagejpg variable and convert those to $imagegif variable?..then md5 them again?

 

Is there a way for me to just edit the last 3 characters of each name?

[phpnoobie9]

I was able to find that all the jpgs had similiar endings and was able to change all of them over using find and replace on dreamweaver. Thanks.

[soycharliente]

If you're storing the MD5 hash of the filename, you can't just change the last 3 characters. Unless it's actually stored as something that looks like 3847a9bc97d0e97.jpg

 

I'm assuming that you hashed the entire filename including the extension.

 

You'd have something LIKE this:

<?php
$list = array('one', 'two', 'three'); // the file names without the extensions
foreach ($list as $pic)
{
$imagejpg = $pic.".jpg";
$imagegif = $pic.".gif";
$sql = "UPDATE `table` SET `image`='MD5($imagegif)' WHERE `image`='MD5($imagejpg)'";
// run the query
}
?>