My Cooking Blog';
exit;
}
exit;
$link_id = @mysql_connect("localhost","chatter_blogs","biteme") or die ("");
$db = @mysql_select_db("chatter_blogs");
$query = "SELECT title,newurl from bmc_posts";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
$t1 = $row[title];
$postid = $row[newurl];
echo ''.$t1.'
';
}
exit;
$query = "SELECT id,title from bmc_posts";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
$t1 = $row[title];
$postid = $row[id];
//$t1 = str_replace("'","",$t1);
$t2=$t1;
//$t2 = str_replace(":","",$t1);
//$t2 = str_replace(":","",);
//$t2 = ereg_replace("[^[:space:]a-zA-Z0-9]", "", $t1);
$t2=str_replace(" ","-",trim(ereg_replace("[^-[:space:]a-zA-Z0-9]", "", $t2)));
$t2 = strtolower($t2);
//echo $t1 .' = '.$t2.'
';
//$result2 = mysql_query("UPDATE bmc_posts SET newurl='".mysql_real_escape_string($t2)."' where id=$postid limit 1");
//echo "UPDATE bmc_posts SET newurl='".mysql_real_escape_string($t2)." where id=$postid limit 1";
}
?>