<?php

	/* 
	** get information about story from database
	*/
	$Query = "SELECT n.Name, n.Description, n.Resource, s.Author, s.Date, s.Body ";
	$Query .= "FROM node n, story s ";
	$Query .= "WHERE n.ID=s.Node AND n.ID=$node ";
	
	$DatabaseResult = mysql_query($Query, $DatabaseLink);
	
	$numRows = mysql_NumRows($DatabaseResult);

	if($numRows > 0)
	{
		$DatabaseRow = mysql_fetch_row($DatabaseResult);
		$Name = $DatabaseRow[0];
		$Description = $DatabaseRow[1];
		$Resource = $DatabaseRow[2];
		$Author = $DatabaseRow[3];
		$Date = $DatabaseRow[4];
		$Body = $DatabaseRow[5];
		
		print("<H1>$Name</H1>\n");
		print("<P>\n");
		print("$Description\n");
		
		print("<P>\n");
		print("<A HREF=\"$Resource\">$Resource</A>\n");
		
		print("<P>\n");
		print("Author: $Author\n");
		
		$monthName = array(1=> "January",  "February",  "March", 
             "April",  "May",  "June",  "July",  "August", 
             "September",  "October",  "November",  "December");
             
        $DateYear = strtok($Date, "-");
        $DateMonth = $monthName[intval(strtok("-"))];
        $DateDay = strtok("-");
        
        print("<P>\n");
        print("$DateMonth $DateDay, $DateYear\n");
        		
		print("<P>\n");
		print("$Body\n");
			
	}
	else
	{
		print("Error.  Couldn't find story.");
	}
	
?>	