<?php
header("Content-Type: application/rss+xml; charset=ISO-8859-1");
DEFINE ('DB_USER', 'root');
DEFINE ('DB_PASSWORD', 'root');
DEFINE ('DB_HOST', 'localhost:8888');
DEFINE ('DB_NAME', 'wordpress');
$rssfeed = '<?xml version="1.0" encoding="ISO-8859-1"?>';
$rssfeed .= '<rss version="2.0">';
$rssfeed .= '<channel>';
$rssfeed .= '<title>My RSS feed</title>';
$rssfeed .= '<link>http://www.mywebsite.com</link>';
$rssfeed .= '<description>This is an example RSS feed</description>';
$rssfeed .= '<language>en-us</language>';
$rssfeed .= '<copyright>Copyright (C) 2009 mywebsite.com</copyright>';
$connection = @mysql_connect(localhost, root, root)
or die('Could not connect to database');
mysql_select_db(wordpress)
or die ('Could not select database');
$query = "SELECT * FROM wp_posts,wp_postmeta WHERE `post_status` LIKE 'publish' AND `post_type` LIKE 'job_listing' AND wp_posts.ID = wp_postmeta.post_id ORDER BY post_date DESC";
$result = mysql_query($query) or die ("Could not execute query");
while($row = mysql_fetch_array($result)) {
extract($row);
$rssfeed .= '<item>';
$rssfeed .= '<id>' . $ID . '</id>';
$rssfeed .= '<title>' . $post_title . '</title>';
$rssfeed .= '<description>' . $post_content . '</description>';
$rssfeed .= '<link>' . $guid . '</link>';
$rssfeed .= '<pubDate>' . date("D, d M Y H:i:s O", strtotime($post_date)) . '</pubDate>';
$rssfeed .= '<company>' . ??????? . '</company>';
$rssfeed .= '</item>';
}
$rssfeed .= '</channel>';
$rssfeed .= '</rss>';
echo $rssfeed;
?>
