can you help me please what should i put to my code?
can you help me please what should i put to my code?
pewds12312
Posts: 5Questions: 2Answers: 0
<img src="homepage.jpg" alt="HTML5 Icon" style="width:1500px;height:300px;">
<?php
// Connects to your Database
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("corporate_personnel_order_for_2016") or die(mysql_error());
@$mode = $_GET['mode'];
@$code = $_GET['CODE'];
@$document_title = $_GET['DOCUMENT_TITLE'];
@$process_owner = $_GET['PROCESS_OWNER'];
@$revision = $_GET['REVISION'];
@$date_of_issue = $_GET['DATE_OF_ISSUE'];
if(isset($_POST["submit"])){
$result = mysql_query("SELECT * FROM table2 WHERE CODE=CODE ,DOCUMENT_TITLE=DOCUMENT_TITLE,PROCESS_OWNER=PROCESS_OWNER,REVISION=REVISION,DATE_OF_ISSUE=DATE_OF_ISSUE");
echo "<center>
<
table><tr><th width=200>Code</th><th width=200>Document Title</th><th width=200>Process Owner</th><th width=200>Revision</th><th width=200>Date of Issue</center></th></tr>";
while ($row = mysql_fetch_row($result)) {
echo '
| ' . $row['CODE'] . ' | '; echo '' . $row['DOCUMENT_TITLE'] . ' | '; echo '' . $row['PROCESS_OWNER'] . ' | '; echo '' . $row['REVISION'] . ' | '; echo '' . $row['DATE_OF_ISSUE'] . ' | '; echo '
";
}
}
<!doctype html>
<html>
<head>
<h2><center>Search Personnel Corporate Order</center></h2>
</head>
<body>
CODE: | |
DOCUMENT TITLE: | |
PROCESS OWNER: | |
REVISION: | |
DATE OF ISSUE: | |
</body>
</html>
This discussion has been closed.