require "../mysql.inc.php"; ?>
| rss-feeds |
Feeds avaible$res = mysql_query("SELECT rss_feeds.*, COUNT(rss_news.id) AS num FROM rss_feeds, rss_news WHERE rss_feeds.id = rss_news.feed_id AND actif='Y' GROUP BY rss_feeds.id"); echo mysql_error(); while ($feed = mysql_fetch_array($res)) { echo "$feed[title] > ($feed[num] news) |
Last news on earth$res = mysql_query("SELECT *, rss_feeds.title AS feed_title FROM rss_feeds, rss_news WHERE rss_feeds.id = rss_news.feed_id AND actif='Y' AND rss_news.description != '' ORDER BY date_modified DESC LIMIT 50"); echo mysql_error(); while ($new = mysql_fetch_array($res)) { echo "$new[title] "; } ?> |