Hi All,
I am coding the following projectresults.php but am having problems, and need some help:
<?php
include "conn.inc.php";
$student_ID = $_REQUEST['student'];
$query = "SELECT *
FROM lecturer, student_project, project_assess
WHERE lecturer.lecturer_ID=project_assess.lecturer_ID
AND student_project.project_ID=project_assess.project_ID
AND student_ID='$student_ID' ";
$result = mysql_query($query)
or die(mysql_error());
while (mysql_num_rows($result) > 0 && $array = mysql_fetch_array($result) && isset('final_project_mark')) {
"<table width=\"62%\" border=\"0\"> " .
"<tr bgcolor=\"#9AB6F8\"> " .
"<td width=\"32%\" bgcolor=\"#9AB6F8\"><p class=\"style1\"><strong>Lecturer Name:</strong>$array['lecturer_name']</p> " .
"<p class=\"style1\"><strong>Lecturer Role:</strong>$array['role']</p></td> " .
"<td width=\"30%\" bgcolor=\"#9AB6F8\"><div align=\"center\"><strong><span class=\"style1\">Project Section </span></strong></div></td> " .
"<td width=\"26%\" bgcolor=\"#9AB6F8\"><div align=\"center\"><strong><span class=\"style1\">Section Marks </span></strong></div></td> " .
"<td width=\"12%\" bgcolor=\"#9AB6F8\"><div align=\"center\"><strong><span class=\"style1\">Total </span></strong></div></td> " .
"</tr> " .
"<tr> " .
"<td rowspan=\"3\" bgcolor=\"#E2E2F2\"><span class=\"style1\">Project Initiation Document </span></td> " .
"<td bgcolor=\"#E2E2F2\"><div align=\"center\"><span class=\"style1\">Project Justification</span></div></td> " .
"<td bgcolor=\"#E2E2F2\"><div align=\"center\"><span class=\"style1\">$array['PID_project_just_mark']</span></div></td> " .
"<td rowspan=\"3\" bgcolor=\"#E2E2F2\"><div align=\"center\"><strong><span class=\"style1\">$array['PID_total_mark']</span></strong></div></td> " .
"</tr> " .
"<tr> " .
"<td bgcolor=\"#E2E2F2\"><div align=\"center\"><span class=\"style1\">Project Approach & Plans </span></div></td> " .
"<td bgcolor=\"#E2E2F2\"><div align=\"center\"><span class=\"style1\">$array['PID_project_approach_plans_mark']</span></div></td> " .
"</tr> " .
"<tr> " .
"<td bgcolor=\"#E2E2F2\"><div align=\"center\"><span class=\"style1\">Research</span></div></td> " .
"<td bgcolor=\"#E2E2F2\"><div align=\"center\"><span class=\"style1\">$array['PID_research_mark']</span></div></td> " .
"</tr> " .
"<tr bgcolor=\"#F2F2FF\"> " .
"<td rowspan=\"4\" bgcolor=\"#F2F2FF\"><span class=\"style1\">Project Report </span></td> " .
"<td bgcolor=\"#F2F2FF\"><div align=\"center\"><span class=\"style1\">Analysis</span></div></td> " .
"<td bgcolor=\"#F2F2FF\"><div align=\"center\"><span class=\"style1\">$array['report_analysis_mark']</span></div></td> " .
"<td rowspan=\"4\"><div align=\"center\"><strong><span class=\"style1\">$array['report_final_mark']</span></strong></div></td> " .
"</tr> " .
"<tr> " .
"<td bgcolor=\"#F2F2FF\"><div align=\"center\"><span class=\"style1\">Design</span></div></td> " .
"<td bgcolor=\"#F2F2FF\"><div align=\"center\"><span class=\"style1\">$array['report_design_mark']</span></div></td> " .
"</tr> " .
"<tr> ".
"<td bgcolor=\"#F2F2FF\"><div align=\"center\"><span class=\"style1\">Impl/Eval</span></div></td> " .
"<td bgcolor=\"#F2F2FF\"><div align=\"center\"><span class=\"style1\">$array['report_impl_eval_mark']</span></div></td> " .
"</tr> " .
"<tr> " .
"<td bgcolor=\"#F2F2FF\"><div align=\"center\"><span class=\"style1\">Review/Conclusion</span></div></td> " .
"<td bgcolor=\"#F2F2FF\"><div align=\"center\"><span class=\"style1\">$array['report_review_con>mark']</span></div></td> " .
"</tr> " .
"<tr bgcolor=\"#E2E2F2\"> " .
"<td bgcolor=\"#E2E2F2\"><span class=\"style1\">Poster Presentation</span></td> " .
"<td bgcolor=\"#E2E2F2\"><div align=\"center\"><span class=\"style1\">Poster</span></div></td> " .
"<td bgcolor=\"#E2E2F2\"><div align=\"center\"><span class=\"style1\">echo $array['poster_mark'];</span></div></td> " .
"<td><div align=\"center\"><strong><span class=\"style1\">$array['final_poster_mark']</span></strong></div></td> " .
"</tr> " .
"</table> " .
"<table width=\"62%\" border=\"0\"> " .
"<tr bgcolor=\"#F2F2FF\" class=\"style1\"> " .
"<td width=\"88%\">Final Project Mark </td> " .
"<td width=\"12%\" bgcolor=\"#F2F2FF\"><div align=\"center\"><strong>$array['final_project_mark']</strong></div></td> " .
"</tr> " .
"</table> ";
}
?>
Basically what I am trying to do is to SELECT data from the database and for each row that is gathered from $query display in an HTML table. The $query should pull up to 4 rows (each with a different project_assess_ID and the same project_ID). This means that upto 4 lecturers have assessed the 1 project. I also need an isset() on project_final_mark so that the table will only be displayed if the lecturer has finished marking it.
The db layout for project_assess is structured like this:
project_assess_ID
project_ID
lecturer_ID
lecturer_role
student_ID
PID_project_just_mark
PID_project_approach_plans_mark
PID_research_mark
report_analysis_allocation
report_design_allocation
report_impl_eval_allocation
report_analysis_mark
report_design_mark
report_impl_eval_mark
report_review_con_mark
poster_mark PID_final_mark
report_final_mark
poster_final_mark
project_final_mark
date_completed
Not to sure if I have ayed the code out properly, so any help appreciated.
