'; echo ''; $conexiune=mysql_pconnect($server,$user,$pass); if (!conexiune) { die('Cannot connect to mysql ' . mysql_error()); } mysql_select_db($db); $cerere="SELECT * FROM melodie ORDER BY id"; $res=mysql_query($cerere) or die(mysql_error()); $i=1; while($row=mysql_fetch_array($res)) { $xmlurl =str_replace("-", " ", $row['titlu']); $xmlurl=str_replace("&", " ", $xmlurl); $xmlurl=str_replace("`", " ", $xmlurl); $xmlurl=str_replace("'", "", $xmlurl); $xmlurl=str_replace("?", "", $xmlurl); $xmlurl=str_replace("!", "", $xmlurl); $xmlurl=str_replace(":", "", $xmlurl); $xmlurl=str_replace("%", "", $xmlurl); $xmlurl=str_replace("@", "", $xmlurl); $xmlurl=str_replace(",", " ", $xmlurl); $xmlurl=str_replace("_", "", $xmlurl); $xmlurl=str_replace(".", "", $xmlurl); $xmlurl=str_replace("(", "", $xmlurl); $xmlurl=str_replace(")", "", $xmlurl); $xmlurl=str_replace("[", "", $xmlurl); $xmlurl=str_replace("]", "", $xmlurl); $xmlurl=str_replace("/", " ", $xmlurl); $xmlurl=str_replace(" ", " ", $xmlurl); $xmlurl=str_replace(" ", " ", $xmlurl); $xmlurl=str_replace(" ", " ", trim($xmlurl)); $xmlurl=str_replace(" ", "-", $xmlurl); $xmlurl=str_replace("<","",$xmlurl); $xmlurl=str_replace(">","",$xmlurl); $categorie=$row['categorie']; $id=$row['id']; echo ''."\n"; echo ''.$siteurl.'/online/'.$id.'/'.$xmlurl.''; echo '0.9'; echo 'daily'; echo ''."\n"; } echo ''; ?>