<?php
echo'<?xml version="1.0"?>
<rss version="2.0">
<channel>
<title>www.tutsforps.com: Tutorials for Photoshop</title>
<link>http://www.tutsforps.com</link>
<description></description>
<language>en</language>';
include ('/home/hfqmjsoe/domains/tutsforps.com/public_html/connect/connect.php');



$q_all="SELECT * FROM ph_tutorials, categorie_tutorial, ph_tu_categorie
WHERE ph_tutorials.tuto_visable='1'
AND
ph_tutorials.tutorial_id=categorie_tutorial.tutorial_id
AND
categorie_tutorial.categorie_id=ph_tu_categorie.id
ORDER BY date DESC";

		$all=mysql_query($q_all);
		while($list_data=mysql_fetch_array($all))
		{
		$cat_stripped= eregi_replace (" ", "-", $list_data['titel']);
		
		
		$tuto_stripped= eregi_replace (" ", "-", $list_data['tutorial_url']);
		
		echo"
	<item>
		<title>".$list_data ['tutorial_titel']."</title>
		<link>http://www.tutsforps.com/Photoshop-Tutorials/".$cat_stripped."/".$tuto_stripped.".htm</link>
		<description>".$list_data ['tutorial_omschrijving'].".</description>
		<pubDate>".$list_data ['date']."</pubDate>
		<guid>http://www.tutsforps.com/Photoshop-Tutorials/".$cat_stripped."/".$tuto_stripped.".htm</guid>

	</item>
		";
		}

mysql_close();



echo'
</channel>
</rss>';
?>
