help with UPDATE query. - UBB.Developers

i having trouble figuring this one out.

i want to be able to update the location of users pictures.

so in w3t_Users i already have a bunch or records that have values like this.

U_Picture = 'http://www.gixxer.com/uploads/582.gif'

how can i update every occurance of "http://www.gixxer.com/uploads/" with "http://www.gixxer.com/avatars/" while leaving the image names alone.

thanks for any help.

You can certainly do it with a php script

Without having compiled and tested it:

Code

 <br />$strQuery = ""; <br />$strUpdate = ""; <br />$strQuery = "SELECT U_Number, U_Picture FROM w3t_Users"; <br />$sth = $dbh -> do_query($strQuery); <br />while ( list ( $lngNumber, $strPicture ) = $dbh -> fetch_array ( $sth ) ) <br />{ <br />if ( !empty( $strPicture ) ) <br />{ <br />$strNewPicture = str_replace( "/uploads/", "/avatars/", $strPicture ); <br />$strUpdate = "UPDATE w3t_Users SET U_Picture = '$strNewPicture' WHERE U_Number = '$lngNumber'"; <br />$dbh -> do_query ( $strUpdate ); <br />} <br />} <br />$dbh -> finish_sth( $sth ); <br />

Make sure you include the main.inc.php library at the top.

thanks. worked well.

Did it? Damn! Now I know that the compiler in my brain still works LOL