The PHP setup for the master page is as follows:
Code: Select all
mysql_select_db($database_EagleMain, $EagleMain);
$query_Jobs = "SELECT jobID, jobTitle, jobPostdate, jobStatus FROM jobs ORDER BY jobPostdate ASC";
$Jobs = mysql_query($query_Jobs, $EagleMain) or die('<p>Error retrieving jobs from the database!<br> />'.
'Error: ' . mysql_error() . '</p>');
$row_Jobs = mysql_fetch_assoc($Jobs);
$totalRows_Jobs = mysql_num_rows($Jobs);Code: Select all
<td><a href="jobdetail.php?id=$row_Jobsї'jobID']"><?php echo $row_Jobsї'jobID']; ?></a></td>
<td><?php echo $row_Jobsї'jobTitle']; ?></td>
<td><?php echo $row_Jobsї'jobPostdate']; ?></td>
<td><?php echo $row_Jobsї'jobStatus']; ?></td>Code: Select all
mysql_select_db($database_EagleMain, $EagleMain);
$query_Jobs = "SELECT * FROM jobs";
$Jobs = mysql_query($query_Jobs, $EagleMain) or die('<p>Error retrieving job details from the database!<br> />'.
'Error: ' . mysql_error() . '</p>');
$row_Jobs = mysql_fetch_assoc($Jobs);
$totalRows_Jobs = mysql_num_rows($Jobs);
$row_Jobs['jobID'] = $_GET['id'];Code: Select all
]<tr><td>Job ID: <?php echo $row_Jobsї'jobID']; ?></td></tr>
<tr><td>Job Title: <?php echo $row_Jobsї'jobTitle']; ?></td></tr>
<tr><td>Status: <?php echo $row_Jobsї'jobStatus']; ?></td></tr>
<tr><td>Post Date:<?php echo $row_Jobsї'jobPostdate']; ?></td></tr>
<tr><td>Responsibilities: <?php echo $row_Jobsї'jobRespons']; ?></td> </tr>
<tr><td>Qualifications:</strong> <?php echo $row_Jobsї'jobQualif']; ?></td></tr>
<tr><td>Company/Product: <?php echo $row_Jobsї'jobCompany']; ?></td></tr>