Jump to content

concrete

Members
 View Profile  See their activity

  • Posts

    20

  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

concrete's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. concrete
    Hi Muddy_Funster, Unfortunately I don't have that luxury as I have to submit this on Tuesday! Thanks for all your help, it was much appreciated.
  2. concrete
    What I had hope to do was the following: when I access the gradebook.php page I am presented with a list of student data. (see fig1) When I click on the grade icon in the far right hand column I am then directed to gradebook1.php (see fig 2) when I access gradebook1, the idea was that if there was already information in there then I could update the current information and if there was no information then I could add the information. I hope this makes sense. Honestly, I really don't know anymore. Am I really badly off track or is it just a matter of tidying up my poor coding? Thanks again
  3. concrete
    Hi Muddy_Funster No the comments are only in the english table!!! I have attached an image of both table structures. Thanks
  4. concrete
    OK, I have given up on the old code and I have started again! I have duplicated a piece of code that I have used in another page to call records from the database and display them in the fields. I think some of you gave me a hand to get that work as well. I have got this partially working as it calls some of the records from the database but not all the records. It displays the exam and coursework marks but it doesn't show the comments. Also how do I join the two table so the records are connected through the primary key 'upn'? Here is the code. <?php function doquery($query) { $db = "prs"; $link = mysql_connect("localhost","gandalf","bella") or die("Could not connect to server! Error: ".mysql_error()); mysql_select_db($db,$link) or die("Could not select $db! Error: ".mysql_error()); $result = mysql_query($query,$link) or $result = "Query Error!<p>Query: $query<p>Error: ".mysql_error(); return($result); mysql_close($link); } if (isset($_POST['submit'])) { $success=0; $student_upn = mysql_real_escape_string($_POST["stu_upn"]); $query = "select count(*) as numberRecords from english where upn = '".$student_upn."'"; $result = doquery($query); $row = mysql_fetch_array($result); if ($row['numberRecords'] == 0) { $query = "select upn from students where upn = '".$student_upn."'"; $result = doquery($query); $row = mysql_fetch_array($result); $cw_mark = $row['english_cw_mark']; $cw_comment = $row['english_cw_comments']; $exam_mark = $row['english_exam_mark']; $exam_comment = $row['english_exam_comments']; $com_poetry = $row['com_poetry']; $com_creative = $row['com_creative']; $com_lit_int = $row['com_lit_int']; $overall_comment = $row['english_overall_comments']; $insert = "insert into english (upn, english_cw_mark, english_cw_comments, english_exam_mark, english_exam_comments, com_poetry, com_creative, com_lit_int, english_overall_ comments) values ('".$student_upn."','".$cw_mark."','".$cw_comment."', '".$exam_mark.",'".$exam_comment."','".$com_poetry."','".$com_creative."','".$com_lit_int."','".$overall_comment."')"; doquery($insert); } $query = "select * from students where upn = '".$student_upn."'"; $result = doquery($query); if ($result) { $success=1; } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Pupil Record System</title> <link href="css/main.css" rel="stylesheet" type="text/css" /> <style type="text/css"> <!-- .oneColElsCtrHdr #container #mainContent #form1 p label { text-align: left; } td { text-align: left; } .oneColElsCtrHdr #container #mainContent #Add_Student table { text-align: left; } --> </style> </head> <body class="oneColElsCtrHdr"> <div id="container"> <div id="header"> <img src="images/crs.png" width="276" height="100" alt="CRS" /> <!-- Date & Time --> <div class="time"> <?php $mydate = date("D j F, Y - H:i:s"); print "<br><h4>".$mydate."</h4>"; ?> </div><!-- end Date & Time .time --> <!-- end #header --></div> <div id="mainContent"> <!-- Top Menu --> <ul> <a href="index.php" class="myButton">Home</a> <a href="add_student.php" class="myButton">Add Student</a> <a href="del_student.php" class="myButton">Delete Student</a> <a href="gradebook.php" class="myButton">Gradebook</a> <a href="update_record.php" class="myButton">Update Record</a> <a href="student_report.php" class="myButton">Student Report</a> </ul> <!-- End Top Menu --> <h2>Gradebook</h2> <?php $id=$_REQUEST['id']; $firstname=$_REQUEST['firstname']; $surname=$_REQUEST['surname']; $db='prs'; $link=mysql_connect("localhost",".........","......") or die("Cannot Connect to the database!"); mysql_select_db($db,$link) or die ("Cannot select the database!"); $query="SELECT * FROM english WHERE english.upn='".$id."'"; $resource=mysql_query($query,$link) or die ("An unexpected error occured while trying to <b>modify</b> the record, Please try again!"); $result=mysql_fetch_array($resource); echo "<h4>You have accessed (#".$id.") ".$firstname." ".$surname."'s record!</h4>"; ?> <form action="gradebook2.php" method="post"> <form id="Gradebook" name="gradebook" method="post" action="gradebook2.php"> <table width="77%" border="1" align="center" cellpadding="5" cellspacing="0" bordercolor="#de6057"> <tr> <td width="45%" class="footer"> <input type="hidden" name="upn" value="<?php echo $result[0] ?>"> <label class="form_labels">Coursework Mark</label></td> <td width="55%"> <input name="cw_mark" type="text" id="cw_mark" value="<?php echo $result[1] ?>" size="6" maxlength="4" /> </td> </tr> <tr> <td class="footer">Coursework Comment </td> <td> <label> <textarea name="cw_comment" id="cw_comment" cols="35" rows="7" value="<?php echo $result[2] ?>"></textarea> </label> </td> </tr> <tr> <td class="footer"><label class="form_labels">Exam Mark</label></td> <td> <input name="exam_mark" type="text" id="exam_mark" value="<?php echo $result[3] ?>" size="6" maxlength="4"> </td> </tr> <tr> <td class="form_labels">Exam Comment </td> <td> <label> <textarea name="exam_comment" id="exam_comment" cols="35" rows="7" value="<?php echo $result[4] ?>"></textarea> </label> </td> </tr> <tr> <td class="form_labels"><label>Commendation in Poetry</label></td> <td> <select name="com_poetry" id="com_poetry" value="<?php echo $result[5] ?>"> <option value="No Commendation" selected="selected">No Commendation</option> <option value="Commendation Awarded">Commendation Awarded</option> </select> </td> </tr> <tr> <td class="form_labels"><label>Commendation in Creative Writing</label></td> <td> <select name="com_creative" id="com_creative" value="<?php echo $result[6] ?>"> <option selected="selected">No Commendation</option> <option value="Commendation Awarded">Commendation Awarded</option> </select> </td> </tr> <tr> <td class="form_labels">Commendation in Literary Interpretation</td> <td> <select name="com_lit_int" id="com_lit_int" value="<?php echo $result[7] ?>"> <option value="No Commendation" selected="selected">No Commendation</option> <option value="Commendation Awarded">Commendation Awarded</option> </select> </td> </tr> <tr> <td class="form_labels"><label>Overall Comments</label></td> <td> <textarea name="overall_comments" id="overall_comments" cols="35" rows="7" value="<?php echo $result[8] ?>"></textarea> </td> </tr> <tr> <td> </td> <td> <input type="reset" name="Reset" id="Reset" value="Reset Form" /> <input type="submit" name="submit" id="submit" value="Submit Form" /> </td> </tr> </table> </form> <h4><a href="gradebook.php">Grade Another Student</a></h4> <!-- end #mainContent --> </div> <!-- Footer --> <div id="footer"> <p class="footer"> <a href="index.php" class="footer">Home</a> | <a href="add_student.php" class="footer">Add Student</a> | <a href="del_student.php" class="footer">Delete Student</a> | <a href="gradebook.php" class="footer">Gradebook</a> | <a href="update_record.php" class="footer">Update Record</a> | <a href="student_report.php" class="footer">Student Report</a> </p> <!-- end Footer #footer --></div></div> <!-- end #container --></div> </body> </html>
  5. concrete
    That matches my tutor then, ancient and not much help!! It going to be a long long day! Thanks Fergal
  6. concrete
    Hi guys, can't thank you all enough for all your help. I have made all the suggested changes so far. muddy_funster - my tutor gave me this line (i think) $student_upn = (integer) $_POST["stu_upn"]; His comments on the line The syntax of // $student_upn = (integer) $_POST["stu_upn"]; // may seem a bit odd. It means the following: // Assign into the variable $student_upn the value of the string // $_POST["stu_upn"], but before the assignment is made, ensure that // the contents of $_POST["stu_upn"] are translated into an integer. // This translating (or 'casting') is necessary so that the database // query contains the primary key in the required format. I am not getting the following error message ( ! ) Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in ..\gradebook1.php on line 82 which relates to this line print $line['firstname']." ".$line['surname']." (#".$line['upn'].") in set ".$line['class_set']; here is the code in full with amendments <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Pupil Record System</title> <link href="css/main.css" rel="stylesheet" type="text/css" /> <style type="text/css"> <!-- .oneColElsCtrHdr #container #mainContent #form1 p label { text-align: left; } td { text-align: left; } .oneColElsCtrHdr #container #mainContent #Add_Student table { text-align: left; } --> </style> </head> <body class="oneColElsCtrHdr"> <div id="container"> <div id="header"> <img src="images/crs.png" width="276" height="100" alt="CRS" /> <!-- Date & Time --> <div class="time"> <?php $mydate = date("D j F, Y - H:i:s"); print "<br><h4>".$mydate."</h4>"; ?> </div><!-- end Date & Time .time --> <!-- end #header --></div> <div id="mainContent"> <!-- Top Menu --> <ul> <a href="index.php" class="myButton">Home</a> <a href="add_student.php" class="myButton">Add Student</a> <a href="del_student.php" class="myButton">Delete Student</a> <a href="gradebook.php" class="myButton">Gradebook</a> <a href="update_record.php" class="myButton">Update Record</a> <a href="student_report.php" class="myButton">Student Report</a> </ul> <!-- End Top Menu --> <h2>Gradebook</h2> <?php function doquery($query) { $db = "prs"; $link = mysql_connect("localhost","gandalf","bella") or die("Could not connect to server! Error: ".mysql_error()); mysql_select_db($db,$link) or die("Could not select $db! Error: ".mysql_error()); $result = mysql_query($query,$link) or $result = "Query Error!<p>Query: $query<p>Error: ".mysql_error(); mysql_close($link); return($result); } function parseresults($result) { if ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { displayform($line); } else { print "A database problem has occurred. Contact the database administrator<p>"; } } function displayform($line) { print <<<HTML <form action="gradebook2.php" method="post"> <H4>Thank You, print $line['firstname']." ".$line['surname']." (#".$line['upn'].") in set ".$line['class_set']; print ' has been sucessfully added to the system.</h4>'; } HTML; echo " <form id="Gradebook" name="gradebook" method="post" action="gradebook2.php"> <table width="77%" border="1" align="center" cellpadding="5" cellspacing="0" bordercolor="#de6057"> <tr> <td width="45%" class="footer"> <label class="form_labels">Coursework Mark</label></td> <td width="55%"> <input name=\"cw_mark\" type=\"text\" id=\"cw_mark\" value=".$line['english_cw_mark']." size=\"6\" maxlength=\"4\" /> <input type=\"hidden\" name=\"upn\" value=".$line['upn']."> </td> </tr> <tr> <td class=\"footer\">Coursework Comment </td> <td> <label> <textarea name=\"cw_comment\" id=\"cw_comment\" cols=\"35\" rows=\"7\" value=".$line['english_cw_commnents']."></textarea> </label> </td> </tr> <tr> <td class=\"footer\"><label class=\"form_labels\">Exam Mark</label></td> <td> <input name=\"exam_mark\" type=\"text\" id=\"exam_mark\" value=".$line['english_exam_mark']." size=\"6\" maxlength=\"4\"> </td> </tr> <tr> <td class=\"form_labels\">Exam Comment </td> <td> <label> <textarea name=\"exam_comment\" id=\"exam_comment\" cols=\"35\" rows=\"7\" value=".$line['english_exam_comments']."></textarea> </label> </td> </tr> <tr> <td class=\"form_labels\"><label>Commendation in Poetry</label></td> <td> <select name=\"com_poetry\" id=\"com_poetry\" value=".$line['com_poetry']."> <option value=\"No Commendation\" selected=\"selected\">No Commendation</option> <option value=\"Commendation Awarded\">Commendation Awarded</option> </select> </td> </tr> <tr> <td class=\"form_labels\"><label>Commendation in Creative Writing</label></td> <td> <select name=\"com_creative\" id=\"com_creative\" value=".$line['com_creative']."> <option selected=\"selected\">No Commendation</option> <option value=\"Commendation Awarded\">Commendation Awarded</option> </select> </td> </tr> <tr> <td class=\"form_labels\">Commendation in Literary Interpretation</td> <td> <select name=\"com_lit_int\" id=\"com_lit_int\" value=".$line['com_lit_int']."> <option value=\"No Commendation\" selected=\"selected\">No Commendation</option> <option value=\"Commendation Awarded\">Commendation Awarded</option> </select> </td> </tr> <tr> <td class=\"form_labels\"><label>Overall Comments</label></td> <td> <textarea name=\"overall_comments\" id=\"overall_comments\" cols=\"35\" rows=\"7\" value=".$line['english_overall_commnents']."></textarea> </td> </tr> <tr> <td> </td> <td> <input type=\"reset\" name=\"Reset\" id=\"Reset\" value=\"Reset Form\" /> <input type=\"submit\" name=\"submit\" id=\"submit\" value=\"Submit Form\" /> </td> </tr> </table> </form>"; } $student_upn = (integer) $_POST["stu_upn"]; $query = "select count(*) as numberRecords from english where upn = ".$student_upn.""; $result = doquery($query); $row = mysql_fetch_array($result); if ($row['numberRecords'] == 0) { $query = "select students.upn from students where students.upn = '".$student_upn."'"; $result = doquery($query); $row = mysql_fetch_array($result); $cw_mark = $row['english_cw_mark']; $cw_comment = $row['english_cw_comments']; $exam_mark = $row['english_exam_mark']; $exam_comment = $row['english_exam_comments']; $com_poetry = $row['com_poetry']; $com_creative = $row['com_creative']; $com_lit_int = $row['com_lit_int']; $overall_comment = $row['english_overall_comments']; $insert = "insert into english (upn, english_cw_mark, english_cw_comments, english_exam_mark, english_exam_comments, com_poetry, com_creative, com_lit_int, english_overall_ comments) values (".$student_upn.",'".$cw_mark."','".$cw_comment."', '".$exam_mark.",'".$exam_comment."','".$com_poetry."','".$com_creative."','".$com_lit_int."','".$overall_comment."',0); print $insert; doquery($insert); } $query = SELECT students.upn as upn, firstname, surname, class_set, from students left join english on students.upn = english.upn where students.upn ='".$student_upn."'"; $result = doquery($query); if (is_resource($result)) { parseresults($result); } else { print "$result"; } print "<a href=\"gradebook.php\"><h4>Grade Another Student</h4></a>"; ?> <!-- end #mainContent --> </div> <!-- Footer --> <div id="footer"> <p class="footer"> <a href="index.php" class="footer">Home</a> | <a href="add_student.php" class="footer">Add Student</a> | <a href="del_student.php" class="footer">Delete Student</a> | <a href="gradebook.php" class="footer">Gradebook</a> | <a href="update_record.php" class="footer">Update Record</a> | <a href="student_report.php" class="footer">Student Report</a> </p> <!-- end Footer #footer --></div></div> <!-- end #container --></div> </body> </html>
  7. concrete
    Hi Muddy_Funster, Thanks again. I have closed the HTML block now. Really out of my depth on this one. I have spent all day banging my head against a php wall. I think my problem is with the echo command but i'm not sure how to fix it.
  8. concrete
    Hi SergeiSS, I have been looking at this for ages and I can't figure out what I have missed out or put in the wrong place. I know it is going to be something silly. I have looked at the for so long I just see red blobs.
  9. concrete
    Hi all, I am lost again in this PHP world. I am trying to set up a grade book for my reporting system. I have got totally lost in the code and I am need of some help. Many Thanks F <?php function doquery($query) { $db = "prs"; $link = mysql_connect("localhost","gandalf","A3tti2ca") or die("Could not connect to server! Error: ".mysql_error()); mysql_select_db($db,$link) or die("Could not select $db! Error: ".mysql_error()); $result = mysql_query($query,$link) or $result = "Query Error!<p>Query: $query<p>Error: ".mysql_error(); mysql_close($link); return($result); } function parseresults($result) { if ($line = mysql_fetch_array('$result', MYSQL_ASSOC)) { displayform($line); } else { print "A database problem has occurred. Contact the database administrator<p>"; } } function displayform($line) { <<<HTML <form action="gradebook2.php" method="post"> <H4>Thank You, <p> HTML; print $line['firstname']." ".$line['surname']." (#".$line['upn'].") in set ".$line['class_set']; print ' has been sucessfully added to the system.<p>'; echo"<form id=\"Gradebook\" name=\"gradebook\" method=\"post\" action=\"gradebook2.php\"> <table width=\"77%\" border=\"1\" align=\"center\" cellpadding=\"5\" cellspacing=\"0\" bordercolor=\"#de6057\"> <tr> <td width=\"45%\" class=\"footer\"> <label class=\"form_labels\">Coursework Mark</label> </td> <td width=\"55%\"> <input name=\"cw_mark\" type=\"text\" id=\"cw_mark\" value=".$line['english_cw_mark']." tabindex=\"1\" size=\"6\" maxlength=\"4\" /> <input type=\"hidden\" name=\"upn\" value=".$line['upn']."> </td> </tr> <tr> <td class=\"footer\">Coursework Comment </td> <td> <label> <textarea name=\"cw_comment\" id=\"cw_comment\" cols=\"35\" rows=\"7\" value=".$line['english_cw_commnents']."></textarea> </label> </td> </tr> <tr> <td class=\"footer\"><label class=\"form_labels\">Exam Mark</label></td> <td> <input name=\"exam_mark\" type=\"text\" id=\"exam_mark\" value=".$line['english_exam_mark']." tabindex=\"3\" size=\"6\" maxlength=\"4\"> </td> </tr> <tr> <td class=\"form_labels\">Exam Comment </td> <td> <label> <textarea name=\"exam_comment\" id=\"exam_comment\" cols=\"35\" rows=\"7\" value=".$line['english_exam_comments']."></textarea> </label> </td> </tr> <tr> <td class=\"form_labels\"><label>Commendation in Poetry</label></td> <td> <select name=\"com_poetry\" id=\"com_poetry\" value=".$line['com_poetry']."> <option value=\"No Commendation\" selected=\"selected\">No Commendation</option> <option value=\"Commendation Awarded\">Commendation Awarded</option> </select> </td> </tr> <tr> <td class=\"form_labels\"><label>Commendation in Creative Writing</label></td> <td> <select name=\"com_creative\" id=\"com_creative\" value=".$line['com_creative']."> <option selected=\"selected\">No Commendation</option> <option value=\"Commendation Awarded\">Commendation Awarded</option> </select> </td> </tr> <tr> <td class=\"form_labels\">Commendation in Literary Interpretation</td> <td> <select name=\"com_lit_int\" id=\"com_lit_int\" value=".$line['com_lit_int']."> <option value=\"No Commendation\" selected=\"selected\">No Commendation</option> <option value=\"Commendation Awarded\">Commendation Awarded</option> </select> </td> </tr> <tr> <td class=\"form_labels\"><label>Overall Comments</label></td> <td> <textarea name=\"overall_comments\" id=\"overall_comments\" cols=\"35\" rows=\"7\" value=".$line['english_overall_commnents'].'"></textarea> </td> </tr> <tr> <td> </td> <td> <input type=\"reset\" name=\"Reset\" id=\"Reset\" value=\"Reset Form\" tabindex=\"12\" /> <input type=\"submit\" name=\"submit\" id=\"submit\" value=\"Submit Form\" tabindex=\"11\" /> </td> </tr> </table> </form>"; } $student_upn = (integer) $_POST["stu_upn"]; $query = "select count(*) as numberRecords from english where upn = ".$student_upn.""; $result = doquery($query); $row = mysql_fetch_array($result); if ($row['numberRecords'] == 0) { $query = "select students.upn from students where students.upn = '".$student_upn."'"; $result = doquery($query); $row = mysql_fetch_array($result); $cw_mark = $row['english_cw_mark']; $cw_comment = $row['english_cw_comments']; $exam_mark = $row['english_exam_mark']; $exam_comment = $row['english_exam_comments']; $com_poetry = $row['com_poetry']; $com_creative = $row['com_creative']; $com_lit_int = $row['com_lit_int']; $overall_comment = $row['english_overall_comments']; $insert = "insert into english (upn, english_cw_mark, english_cw_comments, english_exam_mark, english_exam_comments, com_poetry, com_creative, com_lit_int, english_overall_ comments) values (".$student_upn.",'".$cw_mark."','".$cw_comment."', '".$exam_mark.",'".$exam_comment."','".$com_poetry."','".$com_creative."','".$com_lit_int."','".$overall_comment."',0); print $insert; doquery($insert); } $query = select students.upn as upn, firstname, surname, class_set, from customers left join english on students.upn = english.upn where students.upn = ".$student_upn."; $result = doquery($query); if (is_resource($result)) { parseresults($result); } else { print "$result"; } print "<a href=\"gradebook.php\"><h4>Grade Another Student</h4></a>"; ?>
  10. concrete
    Thanks everyone for all your help! Cheers Andy-H, thanks for all you help but, my tutor gave us part of this script and we have to stick to that. I would love to insert your code but I would be dock marks for doing so. I figured out my error and all is good in my world until i hit the next php wall!
  11. concrete
    Mundy_Funster: How do I change the doquery function? Thanks
  12. concrete
    Hi Muddy_Funster, I was testing the site late last night and noticed that the data is being populated into the database! Can you help!!
  13. concrete
    Thanks guys, Muddy_Funster I must owe you a pint by now!!! Thanks again.
  14. concrete
    Hi all, I am new to PHP and MySQL and I am expierencing an issue which i need help with. I am creating a pupil record system for an assignment in Uni. we have been given some sample code and we have to build onto this and finish the system. I have created an add a student page and when the student is added I want to move to the next page and then display the record that has been added (see image below) Also see code below <?php print "<H2>Thank you, <i>"; print $_POST['firstname']; print " "; print $_POST[ 'surname']; print "</i> has been sucessfully added to the system.</H2>"; print "<a href=\"add_student.php\"><h4>Add Another Student</h4></a>"; function doquery($query) { $db = "prs"; $link = mysql_connect("localhost","..........","........") or die("Could not connect to server! Error: ".mysql_error()); mysql_select_db($db,$link) or die("Could not select $db! Error: ".mysql_error()); $result = mysql_query($query,$link) or $result = "Query Error!<p>Query: $query<p>Error: ".mysql_error(); mysql_close($link); return($result); } $firstname="'".$_POST['firstname']."'"; $surname="'".$_POST['surname']."'"; $address1="'".$_POST['address1']."'"; $address2="'".$_POST['address2']."'"; $town="'".$_POST['town']."'"; $county="'".$_POST['county']."'"; $postcode="'".$_POST['postcode']."'"; $phone="'".$_POST['phone']."'"; $email="'".$_POST['email']."'"; $class_set="'".$_POST['class_set']."'"; $query = "SELECT MAX(upn) + 1 as upn FROM students"; $result = doquery($query); $row = mysql_fetch_array($result); $upn = $row['upn']; $query = "INSERT INTO students (upn, firstname, surname, address1, address2, town, county, postcode, phone, email, class_set) VALUES ($upn, $firstname, $surname, $address1, $address2, $town, $county, $postcode, $phone, $email, $class_set)"; doquery($query); echo "<table width=\"350px\" border=\"1\" cellspacing=\"0\" cellpadding=\"5\" bordercolor=\"#de5f57\" align=\"center\"> <tr> <td colspan=\"2\"><h3>Recorded Added</h3></td> </tr> <tr> <td width=\"150px\" class=\"form_labels\">Student Number</td> <td width=\"300px\" class=\"table_data\">".$upn."</td> </tr> <tr> <td class=\"form_labels\">First Name</td> <td class=\"table_data\">".$firstname."</td> </tr> <tr> <td class=\"form_labels\">Surname</td> <td class=\"table_data\">".$surname."</td> </tr> <tr> <td class=\"form_labels\">Address 1</td> <td class=\"table_data\">".$address1."</td> </tr> <tr> <td class=\"form_labels\">Address 2</td> <td class=\"table_data\">".$address2."</td> </tr> <tr> <td class=\"form_labels\">Town</td> <td class=\"table_data\">".$town."</td> </tr> <tr> <td class=\"form_labels\">County</td> <td class=\"table_data\">".$county."</td> </tr> <tr> <td class=\"form_labels\">Postcode</td> <td class=\"table_data\">".$postcode."</td> </tr> <tr> <td class=\"form_labels\">Phone Number</td> <td class=\"table_data\">".$phone."</td> </tr> <tr> <td class=\"form_labels\">Email</td> <td class=\"table_data\">".$email."</td> </tr> <tr> <td class=\"form_labels\">Class</td> <td class=\"table_data\">".$class_set."</td> </tr> </table>"; ?>
  15. concrete
    Ahh lad, You're a legend Really Appreciate your help!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.