< ? php
$DBConnect = mysqli_connect('localhost', 'root', '', 'phpbb');
mysqli_select_db($DBConnect, "phpbb");
$sql = "SELECT topic_title, topic_views, topic_id, forum_id FROM phpbb_topics";
$sql_execute=mysqli_query($DBConnect, $sql)or die(mysqli_error());
while ($row = mysqli_fetch_row($sql_execute)) {
echo "Topic Id: ".$row[2]." - Topic Title:".$row[0]."
";
$oldText="Ask the Analyst";
$newText="Analyst Corner";
$formattedData = str_replace($oldText, $newText, $row[0]);
echo $formattedData;
$updateQuery = "UPDATE phpbb_topics SET topic_title='".$formattedData."' WHERE topic_id='".$row[2]."'";
mysqli_query($DBConnect, $updateQuery) or die(mysqli_error());
}
? >
Monday, March 23, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment