This code assumes that you have one column in your table that you need cleaned.
Here are two alternate solutions.
$pairs = array('link'=>'hypershooter', 'another'=>'Batooter');
foreach($pairs as $original=>$replacement){
$strSQL = "
UPDATE jbo SET linktext =
REPLACE(linktext, '$original', '$replacement')
";
$rs = @mysql_query($strSQL, $c) or die("<p>Couldn't run query</p>
<p><strong>$strSQL</strong></p> <p>". mysql_error() . "</p>");
echo $strSQL . '<br>';
}
or, via PHP:
$original = array('link', 'another'); //note the diff
$replacement = array('hypershooter', 'batooter'); //note the diff
$strSQL = "SELECT id, linktext FROM jbo";
$rs = @mysql_query($strSQL, $c) or die("<p>Couldn't run query</p> <p><strong>$strSQL</strong></p> <p>". mysql_error() . "</p>");
if(0 == mysql_num_rows($rs)){
echo 'Nothing to replace!';
}else{
while($line = mysql_fetch_array($rs)){
$tmp = $line['linktext'];
$tmp = str_replace($original, $replacement, $tmp);
$child_sql = "UPDATE jbo SET linktext='$tmp' WHERE id=".$line['id'];
$child_rs = @mysql_query($child_sql, $c) or die("<p>Couldn't run query</p> <p><strong>$strSQL</strong></p> <p>". mysql_error() . "</p>"); //child_rs is here if you want rows affected.
echo $child_sql . '<br>';
}
}
The table structure is from an earlier post on this board (not sure if the number I jotted down was topic or post: 43169).
CREATE TABLE `jbo` (
`id` bigint(20) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`date` date NOT NULL default '0000-00-00',
`intro` text NOT NULL,
`image` varchar(255) NOT NULL default '',
`link` varchar(255) NOT NULL default '',
`linktext` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;
--
-- Dumping data for table `jbo`
--
INSERT INTO `jbo` VALUES (1, 'Article 1', '2006-03-21', 'This is the intro to article one', 'http://example.com/cl/templates/c/bg.gif', 'index.php', 'Go to index');
INSERT INTO `jbo` VALUES (2, 'Article 2', '2006-03-22', 'This is article two. How do you like it.', 'http://example.com/cl/templates/c/bg.gif', 'index.php', 'another link to the homepage');
INSERT INTO `jbo` VALUES (3, 'Article 3', '2006-03-22', 'Yet the 3rd', 'http://example.com/cl/templates/c/bg.gif', 'sitemap.php', 'Hah, a link to the sitemap');
INSERT INTO `jbo` VALUES (4, 'Fourth', '2006-03-22', 'adfbl;kfnb;lknwergv', 'image_missing.gif', 'oldskool.asp', 'A link to old skool');
INSERT INTO `jbo` VALUES (5, 'Fifth Article', '2006-03-22', 'Woo, the 5th', 'http://example.com/cl/templates/c/bg.gif', 'index.php', 'another link to the homepage');
INSERT INTO `jbo` VALUES (6, 'Sixth', '2006-03-22', 'This is where it should start messing up?', 'http://example.com/cl/templates/c/bg.gif', 'sitemap.pl', 'A perl sitemap!!!');
INSERT INTO `jbo` VALUES (7, 'Seventh', '2006-03-22', 'Blarg', 'http://example.com/cl/templates/c/bg.gif', 'index.php', 'another link to the homepage');
INSERT INTO `jbo` VALUES (8, 'eight 888', '2006-03-22', 'Sigh, almost done', 'http://example.com/cl/templates/c/bg.gif', 'sitemap.pl', 'A perl sitemap!!!');
INSERT INTO `jbo` VALUES (9, 'nine', '2006-03-22', 'Ninty', 'http://example.com/cl/templates/c/bg.gif', 'index.php', 'another link to the homepage');
INSERT INTO `jbo` VALUES (10, 'tenth', '2006-03-22', 'almost done', 'http://example.com/cl/templates/c/bg.gif', 'sitemap.pl', 'A perl sitemap!!!');
INSERT INTO `jbo` VALUES (11, 'eleventh', '2006-03-22', 'Does this work, PLZ!>?', 'http://example.com/cl/templates/c/bg.gif', 'index.php', 'another link to the homepage');
I like the first one: more compact, but YMMV :)