preg_replace causing to repeat

Discussion in 'PHP' started by gilgalbiblewheel, Jul 15, 2008.

0
  1. #1
    I think the preg_replace is causing the former result to repeat:
    while($row = mysql_fetch_array($result)){
		$old = preg_replace('#&?nbsp;?#i', ' ', $row['content']);
		$new .= preg_replace("/[^ -þ]/", "", $old);
		$sql_record2 = "INSERT INTO correction_nbsp (".$acronym."_pages_id, content_before, content_after)
		VALUES (".$row['id'].", '".$row['content']."', '".$new."')";
		mysql_query($sql_record2,$con) or die(mysql_error());
		echo $sql_record2."<br />\n";
    }
    PHP:

     
    gilgalbiblewheel, Jul 15, 2008 IP
  2. sastro

    sastro Well-Known Member

    Messages:
    214
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    105
    #2
    Remove the "." in $new .=
     
    sastro, Jul 15, 2008 IP
  3. gilgalbiblewheel

    gilgalbiblewheel Well-Known Member

    Messages:
    435
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    101
    #3
    simple as that eh? It worked.
     
    gilgalbiblewheel, Jul 16, 2008 IP