PHP and Oracle

Can anyone tell me why when this scripts find a project that matches the criteria, it prints out its name etc. 5 or so times. And why, when I try to put it into a table it gives me a parse error on line 49. Georgina

<html> <head> <title>Project Database - Project Search</title> </head> <body bgcolor="#9966FF" link="lime" vlink="yellow"> <div align="center"><img src="compSciPageBanner.gif"/></div> <h1 align="center">Project Search</h1> <form action="http://users.aber.ac.uk/geb97/search1.php4" method="POST"> <h2 align="center">Please select the relevant module and then check the area(s) that may interest you</h2> <h4 align="center"> If, for example, you would like to see all projects that involve Java, check the Java box. If you would like only those that involve both Java and databases, check both boxes. You must check at least one box</h4> <p> <input type="radio" name="moduleID" value="CS39030" checked="checked"><big>CS39030</big><br/> <input type="radio" name="moduleID" value="CS39110"><big>CS39110</big><br/> <input type="radio" name="moduleID" value="CS49060"><big>CS49060</big><br/> <input type="radio" name="moduleID" value="CSM9060"><big>CSM9060</big><br/> <input type="radio" name="moduleID" value="CSM9260"><big>CSM9260</big><br/> </p> <p> <input type="radio" name="keyword" value="java" checked="checked"><big>Java</big><br/> <input type="radio" name="keyword" value="telematics"><big>Telematics</big><br/> <input type="radio" name="keyword" value="artificialIntelligence"><big>Artificial Intelligence</big><br/> <input type="radio" name="keyword" value="databases"><big>Databases</big><br/> <input type="radio" name="keyword" value="68HC11"><big>68HC11 Assembly Language</big><br/> <input type="radio" name="keyword" value="web"><big>Web Development</big><br/> <input type="radio" name="keyword" value="others"><big>Other Programming Languages</big><br/> </p> <p> <div align="center"><input type="submit" name="submit" value="Submit"/> <input type="reset" value="Reset"/></div> </p> </form> <div align="center"> <pre> <a href = "http://www.aber.ac.uk">Return to UWA Home Page</a> </pre></div> <div align="center"> <pre> <a href = "http://www.aber.ac.uk/compsci">Return to Computer Science Home Page</a> </pre></div> <div align="center"> <pre> <a href = "mainMenu.html">Return to Project Database Main Menu</a> </pre></div> </body> </html> <html> <head> <title>Project Database - Search Results</title> </head> <body bgcolor="#9966FF" link="lime" vlink="yellow"> <div align="center"><img src="compSciPageBanner.gif"/></div> <?php if ($submit == "Submit") { // The submit button was clicked! // Get the input and use it to retrieve information from the database. //make a connection to the database PutEnv("ORACLE_HOME=/usr/local/applic/oracle/816"); $connection = OCILogon("geb97","f8s0g99","trdb"); //if a connection to the database is not made output a message if (!$connection) { echo "I couldn't make a connection!"; exit; } //formulate the query $query = "SELECT PROJECT.originator, PROJECT.title, PROJECT.projectID, PROJECT.status, PROJECT.specialSkills, PROJECT.moduleID from PROJECT, PROJKEY, KEYWORD, MODULE WHERE PROJECT.projectID=PROJKEY.projectID AND KEYWORD.keyID=PROJKEY.keyID AND PROJECT.moduleID='$moduleID' AND KEYWORD.keyword='$keyword'"; //parse the statement $qry_statement = OCIParse ($connection, $query); //or die ("Couldn't parse statement"); //execute the query statement OCIExecute($qry_statement); //or die ("Couldn't execute query"); echo "<table align=\"center\" border=\"1\" cellpadding=\"8\" cellspacing=\"2\" bgcolor=\"silver\">"; echo " <tr valign=\"center\"><th>ORIGINATOR</th><th>TITLE</th><th>PROJECT NUMBER</th><th>AVAILABILITY</th><th>SPECIAL SKILLS</th></tr> //retrieve the results of the query statement and present them in the following way while (ocifetch($qry_statement)) { echo "The Originator is:" .OCIresult($qry_statement, 'ORIGINATOR')."<br/>"; echo "The title is:" .OCIresult($qry_statement, 'TITLE')."<br />"; echo "The projectID is: ". OCIresult($qry_statement, 'PROJECTID')."<br />"; echo "The availabilty is: ". OCIresult($qry_statement, 'AVAILABILITY')."<br />"; echo "The special skills are: ". OCIresult($qry_statement, 'SPECIALSKILLS')."<br />"; //echo "<tr align =\"center\"><td>" .OCIresult($qry_statement, 'ORIGINATOR'). "</td></tr>"; //echo "<tr align=\"center\"><td>" .OCIresult($qry_statement, 'TITLE'). "</td></tr>"; //echo "<tr align=\"center\"><td>" .OCIresult($qry_statement, 'PROJECTID'). "</td></tr>"; //echo "<tr align=\"center\"><td>" .OCIresult($qry_statement, 'AVAILABILITY'). "</td></tr>"; //echo "<tr align=\"center\"><td>" .OCIresult($qry_statement, 'SPECIALSKILLS'). "</td></tr>"; } //log off the database OCILogoff ($connection); } ?> <div align="center"> <pre> <a href = "http://www.aber.ac.uk">Return to UWA Home Page</a> </div> <div align="center"> <pre> <a href = "http://www.aber.ac.uk/compsci">Return to Computer Science Home Page</a> </pre></div> <div align="center"> <pre> <a href = "mainMenu.html">Return to Project Database Main Menu</a> </pre></div> </body> </html>