<?php 
echo '<?xml version="1.0"';
echo '?';
echo '>';
?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN"
"http://www.wapforum.org/DTD/wml_1.1.xml">

<wml>
<img src="fusionlogo.wbmp" alt="Fusion Logo" align="top" hspace="0" vspace="0"/> 
<br>
<?php

						include "../phpstuff.php";
						include "../phpfunctions.php";

						/* Performing SQL query */
						$query = "SELECT * FROM fusionnews order by date DESC, time DESC limit 0,10 ";
						$result = mysql_query($query) or die("Query failed : " . mysql_error());


						$num_rows = mysql_num_rows($result);

						for($i = 0; $i<$num_rows; $i++){
														
							echo '<card id=';
							echo mysql_result($result, $i,"pk");
							echo ' title="';
							echo mysql_result($result, $i,"subject");
							echo '">';
							echo '<p>';
													  
						  $hyperlink= mysql_result($result, $i,"hyperlink");
						 if($hyperlink == ""){
						  echo '<a href="/fusion/wap/item.wml?pk=';
							echo mysql_result($result, $i,"pk");
							echo '" >';
						}else{
							echo '<a href="http://';
							echo $hyperlink;
							echo '" >';}
						  echo mysql_result($result, $i,"subject");
							echo '</a>';

						  echo '<br>';
						  $newsdate= mysql_result($result, $i,"date");
                        	echo convertdate($newsdate);
                        	echo '&nbsp;:&nbsp;';
                          $newstime= mysql_result($result, $i,"time");
                        	echo converttime($newstime);
                        echo '<br>';
                        
                        $newsstory= mysql_result($result, $i,"report");
                        if($newsstory <> ""){
                        echo substr($newsstory,0,150);
                        echo '...';
                        echo '</p>';
						echo '</card>';
						}
					}
               ?></wml>
