View difference between Paste ID: yfH5A1G5 and sLDx6H8m

-while($database_data = mysql_fetch_array($get_data, MYSQL_ASSOC))
+<?php
 set_time_limit(120);
 
 
 	// Get Functions
 	require_once("functions.php");
 
 	// Check login status
 	//check_login();
 
 	// Connect to access database
 	$database_connect = samples_connect();
 
 	// Detect pulldown menu options
 	if (isset($_GET['smd_number']))
 	{
 		// SMD Number set
 		$get_data = mysql_query("SELECT * FROM samples_table WHERE request_received='0' AND request_smd_number='".$_GET['smd_number']."' ORDER BY request_date DESC");
 	}
 	else if (isset($_GET['request_supplier']))
 	{
 		// Supplier Name set
 		$get_data = mysql_query("SELECT * FROM samples_table WHERE request_received='0' AND request_supplier='".$_GET['request_supplier']."' ORDER BY request_date DESC");
 	}
 	else if (isset($_GET['request_desc']))
 	{
 		// Brief Description
 		$get_data = mysql_query("SELECT * FROM samples_table WHERE request_received='0' AND request_brief_description='".$_GET['request_desc']."' ORDER BY request_date DESC");
 	}
 	else if (isset($_GET['request_required']))
 	{
 		// Request required for
 		$get_data = mysql_query("SELECT * FROM samples_table WHERE request_received='0' AND request_required_for='".$_GET['request_required']."' ORDER BY request_date DESC");
 	}
 	else
 	{
 		$get_data = mysql_query("SELECT * FROM samples_table WHERE request_received='0' ORDER BY request_date DESC");
 	}
 
 	$get_smd_number_pulldown = mysql_query("SELECT request_smd_number FROM samples_table WHERE request_received='0' GROUP BY request_smd_number ORDER BY request_smd_number ASC");
 	$get_request_supplier_pulldown = mysql_query("SELECT request_supplier FROM samples_table WHERE request_received='0' GROUP BY request_supplier ORDER BY request_supplier ASC");
 	$get_request_brief_description_pulldown = mysql_query("SELECT request_brief_description FROM samples_table WHERE request_received='0' GROUP BY request_brief_description ORDER BY request_brief_description ASC");
 	$get_request_required_for = mysql_query("SELECT request_required_for FROM samples_table WHERE request_received='0' GROUP BY request_required_for ORDER BY request_required_for ASC");
 
 	if (!$get_data || !$get_smd_number_pulldown || !$get_request_supplier_pulldown)
 	{
 			echo "Could not get data";
 			exit();
 	}
 	else
 	{
 
 	// Include Header
 	require_once ("header.php");
 
 
 	echo '<table class="table" cellpadding="10">
 
 	<thead>
 		<tr>
 			<th><b>View Full / Edit</b></td>
 			<th><b>Request<br />Date</b></td>
 			<th><b>Required<br/>Date</b></td>
 			<th><b>SMD<br />Number</b></td>
 			<th><b>Supplier</b></td>
 			<th><b>Brief Description</b></td>
 			<th><b>Required For / Customer</b></td>
 			<th><b>Confirmed<br />Completion<br />Date</b></td>
 			<th><b>Request Comments</b></td>
 			<td><b>Potential Issues</b></td>
 		</tr>
 	</thead>';
 
 		echo '<tr>';
 		echo '<td></td>';
 		echo '<td></td>';
 		echo '<td></td>';
 		echo '<td style="background-color: #FFBEA8; padding-top: 10px;"><select id="smd_number_pulldown" onchange="changeSMDNumber();">
 		<option value="">Select one</option>';
 
 			while ($smd_number_pulldown_data = mysql_fetch_array($get_smd_number_pulldown, MYSQL_ASSOC))
 			{
 				echo '<option value="?smd_number='.$smd_number_pulldown_data['request_smd_number'].'" />'.$smd_number_pulldown_data['request_smd_number'].'</option>';
 			}
 
 		echo '</td>';
 		echo '<td style="background-color: #FFBEA8; padding-top: 10px;"><select id="request_supplier_pulldown" onchange="changeSupplier();">
 		<option value="">Select one</option>';
 
 			while ($request_supplier_pulldown_data = mysql_fetch_array($get_request_supplier_pulldown, MYSQL_ASSOC))
 			{
 				echo '<option value="?request_supplier='.$request_supplier_pulldown_data['request_supplier'].'" />'.$request_supplier_pulldown_data['request_supplier'].'</option>';
 			}
 
 		echo '</td>';
 		echo '<td style="background-color: #FFBEA8; padding-top: 10px;"><select id="brief_description_pulldown" onchange="changeBriefDescription();">
 		<option value="">Select one</option>';
 
 			while ($request_brief_description_data = mysql_fetch_array($get_request_brief_description_pulldown, MYSQL_ASSOC))
 			{
 				echo '<option value="?request_desc='.$request_brief_description_data['request_brief_description'].'" />'.$request_brief_description_data['request_brief_description'].'</option>';
 			}
 
 		echo '</td>';
 		echo '<td style="background-color: #FFBEA8; padding-top: 10px;"><select id="required_for_pulldown" onchange="changeRequiredFor();">
 		<option value="">Select one</option>';
 
 			while ($request_required_for_data = mysql_fetch_array($get_request_required_for, MYSQL_ASSOC))
 			{
 				echo '<option value="?request_required='.$request_required_for_data['request_required_for'].'" />'.$request_required_for_data['request_required_for'].'</option>';
 			}
 		echo '<td align="center"><input class="btn" style="padding:9px;" type="submit" value="Show All" onclick="javascript:document.location.href = \'index.php\';" /></td>';
 		echo '<td></td>';
 		echo '<td></td>';
 		echo '</tr>';
 
 			$light_dark = "dark";
 			while($database_data = mysql_fetch_array($get_data, MYSQL_ASSOC))
 			{
 
 					$request_id = stripslashes($database_data['request_id']);
 
 						if ($database_data['request_date'] != "0")
 						{
 							$request_date = date("d/m/Y", $database_data['request_date']);
 						}
 						else
 						{
 							$request_date = "-";
 						}
 
 					$request_smd_number = stripslashes($database_data['request_smd_number']);
 					$request_brief_description = stripslashes($database_data['request_brief_description']);
 					$request_description = wordwrap($database_data['request_description'], 30, '<br />');
 					$request_supplier = stripslashes($database_data['request_supplier']);
 					$request_colours = stripslashes($database_data['request_colours']);
 
 					$request_required_for = stripslashes($database_data['request_required_for']);
 
 					// Show only the first paragraph on the sample log
 					$request_comments = explode("<br />", stripslashes(nl2br($database_data['request_comments'])));
 
-';
+
 
 						if ($database_data['request_confirmed_comp_date'] > "0")
 						{
 							$request_confirmed_completion_date = date("d/m/Y", $database_data['request_confirmed_comp_date']);
 						}
 						else
 						{
 							$request_confirmed_completion_date = " -";
 						}
 
 						if ($database_data['request_confirmed_comp_date2'] > "0")
 						{
 							$request_confirmed_completion_date2 = date("d/m/Y", $database_data['request_confirmed_comp_date2']);
 						}
 						else
 						{
 							$request_confirmed_completion_date2 = " -";
 						}
 
 						if ($database_data['request_confirmed_comp_date3'] > "0")
 						{
 							$request_confirmed_completion_date3 = date("d/m/Y", $database_data['request_confirmed_comp_date3']);
 						}
 						else
 						{
 							$request_confirmed_completion_date3 = " -";
 						}
 
 						if ($database_data['request_confirmed_comp_date4'] > "0")
 						{
 							$request_confirmed_completion_date4 = date("d/m/Y", $database_data['request_confirmed_comp_date4']);
 						}
 						else
 						{
 							$request_confirmed_completion_date4 = " -";
 						}
 
 						if ($database_data['request_confirmed_comp_date5'] > "0")
 						{
 							$request_confirmed_completion_date5 = date("d/m/Y", $database_data['request_confirmed_comp_date5']);
 						}
 						else
 						{
 							$request_confirmed_completion_date5 = " -";
 						}
 
 						if ($database_data['request_confirmed_comp_date6'] > "0")
 						{
 							$request_confirmed_completion_date6 = date("d/m/Y", $database_data['request_confirmed_comp_date6']);
 						}
 						else
 						{
 							$request_confirmed_completion_date6 = " -";
 						}
 
 						if ($database_data['request_date_required'] > "0")
 						{
 							$request_date_required = date("d/m/Y", $database_data['request_date_required']);
 						}
 						else
 						{
 							$request_date_required = "-";
 						}
 
 						if ($database_data['request_date'] > "0")
 						{
 							$request_date = date("d/m/Y", $database_data['request_date']);
 						}
 						else
 						{
 							$request_date = "-";
 						}
 
 					$request_received = stripslashes($database_data['request_received']);
 
 
 					$request_comp_date_array = array($request_confirmed_completion_date6, $request_confirmed_completion_date5, $request_confirmed_completion_date4, $request_confirmed_completion_date3, $request_confirmed_completion_date2, $request_confirmed_completion_date);
 
 
 					// Table Code
 					echo '<tbody>';
 
 
 					// Switch Light/Dark table row background colours
 					if ($light_dark == "dark")
 					{
 							echo '<tr bgcolor="#F1F1F1" valign="top">';
 							$light_dark = "light";
 					}
 					else
 					{
 							echo '<tr bgcolor="#FFFFFF" valign="top">';
 							$light_dark = "dark";
 					}
 
 
 					echo '<td><a style="padding-left: 20px;" href="viewedit.php?id='.$request_id.'"><i class="icon-pencil"></i></a></td>';
 					echo '<td>'.$request_date.'</td>';
 					echo '<td>'.$request_date_required.'</td>';
 					echo '<td>'.$request_smd_number.'</td>';
 					echo '<td>'.$request_supplier.'</td>';
 					echo '<td>'.$request_brief_description.'</td>';
 					echo '<td>'.$request_required_for.'</td>';
 					//echo '<td><b>1.</b>'.$request_confirmed_completion_date.'<br /><b>2.</b>'.$request_confirmed_completion_date2.'<br /><b>3.</b>'.$request_confirmed_completion_date3.'<br /><b>4.</b>'.$request_confirmed_completion_date4.'<br /><b>5.</b>'.$request_confirmed_completion_date5.'<br /><b>6.</b>'.$request_confirmed_completion_date6.'</td>';
 					echo '<td>'.$request_comp_date_array[5].'</td>';
 					echo '<td>'.$request_comments[0].'</td>';
 					echo '<td>'.$request_problems.'</td>';
 					echo '</tr>';
 
 					echo '</tbody>';
 
 			}
 
 	}
 
 	echo '</table>
 ';
 
 
 	// Include Footer
 	require_once("footer.php");
 
 ?>