Untitled

<?xml version="1.0" ?>
<?xml-stylesheet type="text/xsl" href="http://localhost/tvguide/test1.php" ?>
<tvguide
	connection="p03291201_mysql_tvguide_beAch+86"
	xmlns:xsql="urn:oracle-xsql"
	>
	
	<programs>
		<xsql:query>
			SELECT 
					channel.channel_name, program_title,
					TIME_FORMAT( start_time, '%H:%i' ) AS start_time, TIME_FORMAT( finish_time, '%H:%i' ) AS finish_time,
					TIME_FORMAT( (TIMEDIFF(finish_time,start_time)), '%H:%i' ) AS duration, 
					widescreen, subtitles
			FROM 
					program, channel 
			WHERE 
					date = CURRENT_DATE()
			AND
					finish_time BETWEEN CURRENT_TIME()
			AND 
					ADDTIME(CURRENT_TIME(), '01:30:00') 
			AND 
					program.channel_id=channel.channel_id 
			ORDER BY 
					channel_name,start_time;	
		</xsql:query> 
	</programs>
</tvguide>