Rate this script:  I Love it  /   I Hate it

Output feedwordpress database for use in Planet


Code


<?php
$username = "myuser";
$password = "P455w0rd";
$database = "db_name";
$hostname = "127.0.0.1";

$query = "SELECT link_name, link_rss FROM wp_links WHERE link_category=2";

mysql_connect($hostname, $username,$password);
@mysql_select_db($database) or die("Unable to select database");
$result = mysql_query($query);
$num = mysql_numrows($result);
mysql_close();

$i=0;
while($i < $num) {
        $rss = mysql_result($result,$i,"link_rss");
        $name = mysql_result($result,$i,"link_name");

        echo "[".$rss."]\r\n";
        echo "name = ".$name."\r\n";
        $i++;
}
?>

 

 

 
Output feedwordpress database for use in Planet scripts | Output feedwordpress database for use in Planet snippet | Output feedwordpress database for use in Planet example | Output feedwordpress database for use in Planet tutorial | Output feedwordpress database for use in Planet code