<?
	$Query = "SELECT ID, Name, Description, Private, Icon, Layout, DisplayOrder ";
	$Query .= "FROM pathway ";
	$Query .= "WHERE ID=$inputPathway ";
	$DatabaseResult = mysql_query($Query, $DatabaseLink);
	$DatabaseRow = mysql_fetch_row($DatabaseResult);
	$db_ID = $DatabaseRow[0];
	$db_Name = $DatabaseRow[1];
	$db_Description = $DatabaseRow[2];
	$db_Private = $DatabaseRow[3];
	$db_Icon = $DatabaseRow[4];
	$db_Layout = $DatabaseRow[5];
	$db_DisplayOrder = $DatabaseRow[6];
	

	/* 
	** display form for updating pathway 
	*/
	print("<FORM ACTION=\"$ScriptName\" METHOD=\"get\">\n");
	print("<INPUT TYPE=HIDDEN NAME=\"sid\" VALUE=\"$sid\">\n");
	print("<INPUT TYPE=HIDDEN NAME=\"SCREEN\" VALUE=\"edit\">\n");
	print("<INPUT TYPE=HIDDEN NAME=\"ACTION\" VALUE=\"UPDATE_PATHWAY\">\n");
	print("<INPUT TYPE=HIDDEN NAME=\"pathway\" VALUE=\"$pathway\">\n");

	print("<INPUT TYPE=HIDDEN NAME=\"inputPathway\" VALUE=\"$inputPathway\">\n");

	print("Name of Pathway");
	print("<INPUT TYPE=TEXT NAME=\"inputName\" VALUE=\"$db_Name\" SIZE=\"50\"><BR>\n");
	print("<BR>\n");

	print("Descriptive Text");
	print("<TEXTAREA NAME=\"inputDescription\" COLS=\"50\" ROWS=\"10\">$db_Description</TEXTAREA><BR>\n");
	print("<BR>\n");
	
	print("Permission");
	print("<SELECT NAME=\"inputPrivacy\">");
	print("<OPTION VALUE=\"N\"");
	if($db_Private == "N")
	{
		print(" CHECKED");
	}
	print(">Public\n");
	print("<OPTION VALUE=\"Y\"");
	if($db_Private == "Y")
	{
		print(" CHECKED");
	}
	print(">Private\n");
	print("</SELECT><BR>\n");
	print("<BR>\n");

	// get list of images in directory of icons
	
	print("Icon");
	print("<SELECT NAME=\"inputIcon\">\n");
	print("<OPTION VALUE=\"0\"");
	if ($db_Icon == 0)
	{
		print(" SELECTED");
	}
	print(">None\n");
	
	$Icon_Directory = dir($Icon_URL);
		
	while ($current_Image = $Icon_Directory->read())
	{
		if ($current_Image != "." && $current_Image != "..")
		{
			print("<OPTION VALUE=\"$current_Image\"");
			if ($db_Icon == $current_Image)
			{
				print(" SELECTED");	
			}
			print(">$current_Image\n");
		}
	}
	print("</SELECT><BR>\n");
	print("<BR>\n");
		


	print("Number of Columns for Pathway Layout");
	print("<SELECT NAME=\"inputLayout\">");
	print("<OPTION VALUE=\"1\" SELECTED>1\n");
	
	for ($i = 2; $i <= MAX_PATHWAY_COLS; $i++)
	{
		print("<OPTION VALUE=\"$i\"");
		
		if ($db_Layout == $i)
		{
			print(" SELECTED");
		}
		
		print(">$i\n");
	}
	
	print("</SELECT><BR>\n");
	print("<BR>\n");
	
	
	print("Display Order");
	print("<INPUT TYPE=TEXT NAME=\"inputDisplayOrder\" VALUE=\"$db_DisplayOrder\" SIZE=\"5\"><BR>\n");
	print("<BR>\n");


	print("<INPUT TYPE=SUBMIT VALUE=\"Update Pathway\"><BR>\n");
	print("</FORM>\n");

?>