Just a cosmetic question really. Why are the three links I have put in at
the bottom of the script appearing at the top on the WEb page, just beneath
the comp sci banner. How do I get them to appear beneath the table?
Georgina
<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");
//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 teh 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>";
}//end of while statement
//log off the database
OCILogoff ($connection);
}//end of if statement
//provide a link back to teh UWA home page
echo "<div align=\"center\">
<pre>
<a href = \"http://www.aber.ac.uk\";>Return to UWA Home Page</a>
</pre></div>";
//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]
