<? include("config.php3" ); $query="SELECT * FROM chansons"; $result=mysql_query($query); while($a=mysql_fetch_object($result)){ $id=$a->id_lyrics; $chant=$a->parole; $chant=addslashes($chant); $chant2=strip_tags($chant); mysql_query("UPDATE chansons SET parole='$chant2' WHERE id_lyrics='$id'" )or die(mysql_error()); } ?>
ET SA MARCHE MERCI KAYSAX
T'as plus qu'à changer de pseudo.
<? include("config.php" ); $query="SELECT * FROM chansons $result=mysql_query($query); while($row=mysql_fetch_row($result)){ $id=$row[0]; $chant=$row[3]; $search ="<br />"; $replace =""; $chant2 = preg_replace ($search, $replace, $chant); if(mysql_query ("UPDATE chansons SET parole='$chant2' WHERE id_lyrics='$id'" )){ echo "Chason $id_lyrics modifier"; }else{ echo "chanson $id_lyrics : ERREUR"; } } ?>
Config c'est la connection a la bdd