Ok, I have a HTML form, where I can select a module type and a keyword. I then submit this and want a table return with all the projects that fulfil that criteria. However, instead of returning all the projects that fulfil the criteria, it only returns the first one I entered. It doesn't seem to be bringing back any details of projects I entered via the Web site, even though they fill the criteria, and it is only returning those projects entered directly into the database using SQL.
Here's my PHP code:- <! search1.php4> <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 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"); //a paragraph break, so the table doesn't appear right at the top of the page echo "<p>"; //create a table into which the results can be placed 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)) { //insert the results into the table echo "<tr align =\"center\">"; echo "<td>" .OCIresult($qry_statement, 'ORIGINATOR'). "</td>"; echo "<td>" .OCIresult($qry_statement, 'TITLE'). "</td>"; echo "<td>" .OCIresult($qry_statement, 'PROJECTID'). "</td>"; echo "<td>" .OCIresult($qry_statement, 'STATUS'). "</td>"; echo "<td>" .OCIresult($qry_statement, 'SPECIALSKILLS'). "</td>"; echo "</tr>"; //close table and close the paragraph echo "</table>"; echo "</p>"; } //commits the information added to the database OCICommit ($connection); //log off the database OCILogoff ($connection); }//end of if statement //just a note echo "<p><b><div align=\"center\"> If the table above appears empty, this means that no projects fulfil your criteria and you will need to search again </div></b></p>"; //provide a link back to the UWA home page echo "<p><div align=\"center\"> <pre> <a href = \"http://www.aber.ac.uk\">Return to UWA Home Page</a> </pre></div></p>"; //provide a link to the Computer Science Home Page echo "<div align=\"center\"> <pre> <a href = \"http://www.aber.ac.uk/compsci\">Return to Computer Science Home Page</a> </pre></div>"; //provide a link back to the Project Database main menu echo "<div align=\"center\"> <pre> <a href = \"mainMenu.html\">Return to Project Database Main Menu</a> </pre></div>"; ?> <! end of PHP script> </body> </html> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]