Location: PHPKode > projects > Athena Research Assistant > athena-dev-0.1pre-alpha/objects/showDETAILSproject.php
<?php
	$itemID = $_GET["id"];
	$_SESSION["projectID"] = $itemID;
	$getITEM = mysql_query("SELECT * FROM ath_resrc WHERE ath_resrc_id=$itemID");
	
	$ROWgetITEM = mysql_fetch_array($getITEM);
		
	//BEGIN SHOWING WORKS
	echo("<tr>");
	echo("<td valign=\"top\" height=\"10\">");
	echo("</td>");
	echo("</tr>");
	
	echo("<tr>");
	echo("<td align=\"left\" valign=\"top\" class=\"left\">");
	
	if ($ROWgetITEM["ath_projects_groupID"] == $_SESSION["userGROUPID"]){
		
		echo(	"<b>Title: " . 
				"<a href=\"main.php?menu=viewresrc&act=edit&valign=top&type=res&pid=" . $ROWgetITEM["ath_resrc_id"] . "&id=" . $ROWgetITEM["ath_resrc_id"] . "\">" .
				$ROWgetITEM["ath_resrc_title"] . "</a></b><br>");
		
			
			//GET ALL RESOURCES UNDER THIS PROJECT

			$getRESRC = mysql_query("SELECT * FROM ath_resrc WHERE ath_notes_resourceID=$itemID");
			
			if (!$getNOTES){
				echo("<p class=\"red\">getRESRC failed in viewDETAILSproject.php</p>");
				echo(mysql_error());
				exit();
			}
			else{
				echo("<ul>");
			}
					
			//PRINT RESOURCES IN A LIST
			while ($ROWgetNOTES = mysql_fetch_array($getNOTES)){
				echo(	"<li><a href=\"main.php?menu=viewresrc&act=edit&valign=top&type=note&pid=" . $ROWgetITEM["ath_resrc_id"] . "&id=" . $ROWgetNOTES["ath_notes_id"] . "\">" .
						$ROWgetNOTES["ath_notes_heading"] . ".</a>");
						echo("<dl>");
						echo("<dd>" . stripslashes($ROWgetNOTES["ath_notes_text"]));
						echo("</dl>");
			}
					
			if ($getNOTES){
				echo("</ul>");	
			}
	}
	else{
		echo("<p class=\"red\">You are not allowed to view this item!</p>");
	}
?>
Return current item: Athena Research Assistant