re

<?php

/**
*
*	@author: reZo
*	@purpose: Example for tommied on HTS IRC. How to use variable values from the GET HTTP method.
*	@date: 13th October 2006
*
*/

$number = (int) $_GET['messageID'];

if( empty($number) )
{
	$number = 1;
}

$query = "SELECT news_number, news_heading, news_content FROM tbl_news WHERE news_number = '" . $number . "'";

$result = mysql_query($query);

if( is_resource($result) )
{
	if( mysql_num_rows($result) >= 1 )
	{
		while( $row = mysql_fetch_assoc($result) )
		{
			echo '<h1>' . $row['news_heading'] . '</h1>';
			
			echo '<p>' . $row['news_content'] . '</p>';
			
			echo 'Article number, ' . $row['news_number'];
		}
	}
	
	else
	{
		echo 'There are currently no news articles to display.';
	}
}

else
{
	echo 'We failed to check for any news articles, please contact the webmaster.';
}

?>