Location: PHPKode > projects > Poddy > src/maintainance/text.php
<?php
require_once("../config.php");
require_once("lib/db_utils.php");
require_once("lib/rss_utils.php");

$sql = "select * from podcast where description_text = \"\"";
$rs = db_query($sql);
$rows = array();
while ($row = db_next_row($rs)) {
	$rows[] = $row;
}
foreach ($rows as $row) {
	$sql = "update podcast set description_text=\"".mysql_escape_string(html2text($row["description"]))."\" where id=\"".$row["id"]."\"";
	db_query($sql);
	echo $sql;
	echo "<br/>";
}

$sql = "select * from item where description_text = \"\"";
$rs = db_query($sql);
$rows = array();
while ($row = db_next_row($rs)) {
	$rows[] = $row;
}
foreach ($rows as $row) {
	$sql = "update item set description_text=\"".mysql_escape_string(html2text($row["description"]))."\" where id=\"".$row["id"]."\"";
	db_query($sql);
	echo $sql;
	echo "<br/>";
}


?>
Return current item: Poddy