STR_Replace Using MySQL

[SP8600]

Does anyone know why this loop does seam to work however it does not replace the text from the database.

$replace_sqlquery = "SELECT * FROM changetxt";
$replace_result = mysql_query($replace_sqlquery);
$replace_number = mysql_num_rows($replace_result);
$replace_row = mysql_fetch_assoc($replace_result);

$content_replace = $page_row["main_content"]; 
$replace = $replace_row["replace"];
$with = $replace_row["with"];
for ($i=0; $i<$replace_number; $i++) {
$content_replace = str_replace ("$replace","$with",$content_replace);
}

[sarahk]

I haven't used some of the syntax here but it seems to me that you need and UPDATE statement as you are only pulling data out of the database and never putting the changes back in.

[SP8600]

I dont want it to be updated when it is inserted into the database but when it is pulled from the database.

[RedDragon]

first i suggest you read up on mysql_fetch_assoc and mysql_fetch_array on mysql.com, i suggest you should use 2nd here

second $page_row is not declined anywhere

third i think you might try using a while loop like this

$query = "SELECT text,replace,with FROM changetxt";
while($x = mysql_fetch_array($query)) {
$x[text] = str_replace ("$x[replace]","$x[with]","$x[text]");
}

hope that helped you