PRMiller

<? 
	include 'sql/sqlConnect.php';
	$portfolio_title = mysql_escape_string($_GET['ID']);
	
	/* Gets unique ID for portfolio */
	$query ="SELECT portfolio_id FROM Portfolio_Pages where portfolio_title=('$portfolio_title')";
	$result = mysql_query($query);
	$row = mysql_fetch_array($result, MYSQL_ASSOC);
	$portfolio_id = $row['portfolio_id'];
	
	while($portfolio_title_next == ""){
	++$portfolio_id_next;
	$query ="SELECT * FROM Portfolio_Pages where portfolio_id=($portfolio_id_next)";
	$result = mysql_query($query);
	$row = mysql_fetch_array($result, MYSQL_ASSOC);
	$portfolio_title_next = $row['portfolio_title'];
	$portfolio_title = $portfolio_title_next;
	}
	
	if(isset($_POST['next'])){
		$portfolio_id+=1;
		$query ="SELECT * FROM Portfolio_Pages WHERE portfolio_id=('$portfolio_id')";
		$result = mysql_query($query);
		$row = mysql_fetch_array($result, MYSQL_ASSOC);
		$portfolio_title = $row['portfolio_title'];
	} 
	
	$query ="SELECT * FROM Portfolio_Images WHERE portfolio_title='$portfolio_title'";
	$result = mysql_query($query);
	$image_array = array();
	$image_file_location = array();
	
	while($row = mysql_fetch_array($result, MYSQL_ASSOC))
	{
		$image_array[] = $row['image_file_location'];
	}

	include 'sql/sqlClose.php';
	?>