Nothing seems to be working, I am sure there is a small mistake some where! I am going to post the full code for both pages just in case someone can notice somehting which I have missed:
For simplicity I will refer to them has Page 1 and Page 2
Page1:
Code: Select all
<?php
session_start();
if(isset($_POST['job']))
{
$_SESSION ['job'] = $_POST['job'];
}
?>
<?php
// connects to Database
$host="co-project";
$user="conmg";
$password="****";
$conn = mysql_connect($host, $user, $password) or die ('Error connecting to mysql');
$dbname="conmg";
$dbname=@mysql_select_db($dbname, $conn)
or die("Couldn't select database");
////
$query = "SELECT * FROM Job_Spec";
$result = mysql_query($query);
echo "<h1 class='title2'>Upcoming Project Roles</h1>
<p>From the menu below please select the Project Role:</p>
<form id='form2' method='post' action='go.php'>
<p>
<label>
<select name='job' id='job'>";
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
$Project_Name= $row['Project_Name'];
echo "<option value=\"$Project_Name\">$Project_Name</option>";
}
echo "</select></label></p>
<input type='submit' name='notjob' id='button' value='Go' />
</label>
</p>
</form>
";
?>Code: Select all
<?php
session_start();
$getjob = $_SESSION['job'];
?>
$query1 = "SELECT * FROM Job_Spec WHERE Project_Name ='$getjob'";
$result1 = mysql_query($query1)
or die ("Couldn't execute query.");
$colcnt = 0;
while ($row = mysql_fetch_array($result1,MYSQL_ASSOC)) {
{
if (!$colcnt)
{
$colcnt = 7;
}
$colcnt--;{
$Name1 = $row['Project_Name'];
$Java1 = $row['Java'];
$Leadership1 = $row['Leadership'];
$Communication1 = $row['Communication'];
$Teamwork1 = $row ['Team_Work'];
$Problem_Solving1 = $row['Problem_Solving'];
}
}
echo "$Java1";
?>