Jump to content

Chris721

Members
 View Profile  See their activity

  • Posts

    23

  • Joined

  • Last visited

 Content Type 

Everything posted by Chris721

  1. Chris721
    thank you for the help, that works now
  2. Chris721
    its not going online or anything like it, its for a project at university
  3. Chris721
    code now looks like <title>Inputing Travel Detials</title> <header> <h1 align="center"> Adding Travel Detials </h1> <body> <table border="1"> <tr> <td><a href="index.php"> Home Page </a></td> <td><a href="administratorhomepage.html">Administrator Home Page </a></td> <td><a href="viewhomepage.html">View Home Page </a></td> <td><a href="Inputhomepage.html">Input Home Page </a></td> </tr> </table> <center><img src="cyberwarfareimage1.png" alt="Squadron logo" style="width:200px;height:200px" style="middle"></center> <table border="1"> <tr> <td><a href="Changetraveldetials.html">Modify More Travel Detials </a></td> </tr> </table> <?php include "connection.php"; $Applicant_ID = $_POST["Applicant_ID"]; $Method_Of_Travel = $_POST["Method_Of_Travel"]; $Cost = $_POST["Cost"]; $ETA = $_POST["ETA"]; $Main_Gate_Advised = $_POST["Main_Gate_Advised"]; $query = ("UPDATE int_board_applicant SET 'Method_Of_Travel'='$Method_Of_Travel', 'Cost'=$Cost, 'ETA'='$ETA', 'Main_Gate_Advised'='$Main_Gate_Advised' WHERE 'Applicant_ID'='$Applicant_ID'"); $result = mysqli_query($dbhandle, $query) or die(mysqli_error($dbhandle)); if($result){ echo "Success!"; } else{ echo "Error."; } // successfully insert data into database, displays message "Successful". if($query){ echo "Successful"; } else { echo "Data not Submitted"; } //closing the connection mysqli_close($dbhandle) ?> </body>
  4. Chris721
    still getting the error but its moved down to method of travel
  5. Chris721
    I have got rid of the single quotes as it is a numeric value but it is still coming up with the same error
  6. Chris721
    I have been looking at this code most of the morning and do not have a clue what is wrong with the code. I am hoping its not a stupid mistake, can someone please help me out? thank you <title>Inputing Travel Detials</title> <header> <h1 align="center"> Adding Travel Detials </h1> <body> <p> <center><img src="cyberwarfareimage1.png" alt="Squadron logo" style="width:200px;height:200px" style="middle"></center> <table border="1"> <tr> <td><a href="index.php"> Home Page </a></td> <td><a href="administratorhomepage.html">Administrator Home Page </a></td> <td><a href="viewhomepage.html">View Home Page </a></td> <td><a href="Inputhomepage.html">Input Home Page </a></td> <td><a href="traveldetials.html">Enter More Travel Detials </a></td> </table> </p> <?php include "connection.php"; $Applicant_ID = $_POST["Applicant_ID"]; $Method_Of_Travel = $_POST["Method_Of_Travel"]; $Cost = $_POST["Cost"]; $ETA = $_POST["ETA"]; $Main_Gate_Advised = $_POST["Main_Gate_Advised"]; $query = ("UPDATE `int_board_applicant` SET `Method_Of_Travel`=`$Method_Of_Travel', `Cost`=`$Cost', `ETA`='$ETA', `Main_Gate_Advised`='$Main_Gate_Advised' WHERE `Applicant_ID`='$Applicant_ID'"); $result = mysqli_query($dbhandle, $query) or die(mysqli_error($dbhandle)); if($result){ echo "Success!"; } else{ echo "Error."; } // successfully insert data into database, displays message "Successful". if($query){ echo "Successful"; } else { echo "Data not Submitted"; } //closing the connection mysqli_close($dbhandle) ?>
  7. Chris721
    thank you for the help, learning as I go
  8. Chris721
    I changed to $searchq = $sql; and it now works
  9. Chris721
    fixed it, found the problem
  10. Chris721
    sorry my bad
  11. Chris721
    <title>Applicant Data view</title> <p> <center><img src="cyberwarfareimage1.png" alt="Squadron logo" style="width:200px;height:200px" style="middle"></center> <table border="1"> <tr> <td><a href="index.php"> Home Page </a></td> <td><a href="administratorhomepage.html">Administrator Home Page </a></td> <td><a href="viewhomepage.html">View Home Page </a></td> </table> </p> <?php $searchq =($_GET['search']); include "connection.php"; $sql = ("SELECT * FROM applicant WHERE `Firstname` LIKE '$searchq' OR `Lastname` LIKE '$searchq'"); $result = $dbhandle->query($sql) or die($dbhandle->error); echo "<table border='1'> <tr> <th>Applicant Id</th> <th>Firstame</th> <th>Lastname</th> <th>Address</th> <th>Date Of Birth</th> <th>Contact Number</th> <th>Next Of Kin</th> <th>Next Of Kin Address</th> <th>Vetting Date</th> <th>Clearance Expiry</th> <th>Current Employer</th> <th>Date Applied</th> <th>Resubmitting</th> <th>Number Of Previous Attempts</th> <th>Why</th> <th>Qualificaton 1</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 2</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 3</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 4</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 5</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 6</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 7</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 8</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 9</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 10</th> <th>Date Completed</th> <th>Expiry Date</th> </tr>"; if (isset ($_GET["search"])) { $searchq = $_GET["$sql"]; $searchq = ("#[^a-z, A-Z]#i"); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo "<tr>"; echo "<td>" . $row['Applicant_ID'] . "</td>"; echo "<td>" . $row['Firstname'] . "</td>"; echo "<td>" . $row['Lastname'] . "</td>"; echo "<td>" . $row['Address'] . "</td>"; echo "<td>" . $row['DOB'] . "</td>"; echo "<td>" . $row['Telephone_No'] . "</td>"; echo "<td>" . $row['NOK'] . "</td>"; echo "<td>" . $row['NOK_Address'] . "</td>"; echo "<td>" . $row['Vetting_Date'] . "</td>"; echo "<td>" . $row['Clearance_Expiry'] . "</td>"; echo "<td>" . $row['Current_Employer'] . "</td>"; echo "<td>" . $row['Date_applied'] . "</td>"; echo "<td>" . $row['Resubmission'] . "</td>"; echo "<td>" . $row['Number_of_Attempts'] . "</td>"; echo "<td>" . $row['Why'] . "</td>"; echo "<td>" . $row['Qual_1'] . "</td>"; echo "<td>" . $row['Date_Completed_1'] . "</td>"; echo "<td>" . $row['Run_out_date_1'] . "</td>"; echo "<td>" . $row['Qual_2'] . "</td>"; echo "<td>" . $row['Date_Completed_2'] . "</td>"; echo "<td>" . $row['Run_out_date_2'] . "</td>"; echo "<td>" . $row['Qual_3'] . "</td>"; echo "<td>" . $row['Date_Completed_3'] . "</td>"; echo "<td>" . $row['Run_out_date_3'] . "</td>"; echo "<td>" . $row['Qual_4'] . "</td>"; echo "<td>" . $row['Date_Completed_4'] . "</td>"; echo "<td>" . $row['Run_out_date_4'] . "</td>"; echo "<td>" . $row['Qual_5'] . "</td>"; echo "<td>" . $row['Date_Completed_5'] . "</td>"; echo "<td>" . $row['Run_out_date_5'] . "</td>"; echo "<td>" . $row['Qual_6'] . "</td>"; echo "<td>" . $row['Date_Completed_6'] . "</td>"; echo "<td>" . $row['Run_out_date_6'] . "</td>"; echo "<td>" . $row['Qual_7'] . "</td>"; echo "<td>" . $row['Date_Completed_7'] . "</td>"; echo "<td>" . $row['Run_out_date_7'] . "</td>"; echo "<td>" . $row['Qual_8'] . "</td>"; echo "<td>" . $row['Date_Completed_8'] . "</td>"; echo "<td>" . $row['Run_out_date_8'] . "</td>"; echo "<td>" . $row['Qual_9'] . "</td>"; echo "<td>" . $row['Date_Completed_9'] . "</td>"; echo "<td>" . $row['Run_out_date_9'] . "</td>"; echo "<td>" . $row['Qual_10'] . "</td>"; echo "<td>" . $row['Date_Completed_10'] . "</td>"; echo "<td>" . $row['Run_out_date_10'] . "</td>"; echo "</tr>"; } echo "</table>"; } else { echo "0 results"; } } $dbhandle->close(); ?>
  12. Chris721
    I am now getting some data with a error message off Notice: Undefined index: SELECT * FROM applicant WHERE `Firstname` LIKE 'booth' OR `Lastname` LIKE 'booth' in C:\wamp\www\search2.php on line 72. the data is 100% but its getting some
  13. Chris721
    I have switched it round and I have tried changing a few things. things are looking better the code is starting to run as should bar one error Notice: Undefined index: in C:\wamp\www\search2.php on line 72
  14. Chris721
    I am sure there is something wrong around the if ($result->num_rows > 0) { // output data of each row while($row = mysqli_fetch_array($result)) area of the code, if I try to echo anything after that it doesn't work, I have tried everything I know and can't seem to fix it. <title>Applicant Data view</title> <p> <center><img src="cyberwarfareimage1.png" alt="Squadron logo" style="width:200px;height:200px" style="middle"></center> <table border="1"> <tr> <td><a href="index.php"> Home Page </a></td> <td><a href="administratorhomepage.html">Administrator Home Page </a></td> <td><a href="viewhomepage.html">View Home Page </a></td> </table> </p> <?php $searchq =($_GET['search']); include "connection.php"; $sql = ("SELECT * FROM applicant WHERE `Firstname` LIKE '$searchq' OR `Lastname` LIKE '$searchq'"); $result = $dbhandle->query($sql) or die($dbhandle->error); echo "<table border='1'> <tr> <th>Applicant Id</th> <th>Firstame</th> <th>Lastname</th> <th>Address</th> <th>Date Of Birth</th> <th>Contact Number</th> <th>Next Of Kin</th> <th>Next Of Kin Address</th> <th>Vetting Date</th> <th>Clearance Expiry</th> <th>Current Employer</th> <th>Date Applied</th> <th>Resubmitting</th> <th>Number Of Previous Attempts</th> <th>Why</th> <th>Qualificaton 1</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 2</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 3</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 4</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 5</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 6</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 7</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 8</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 9</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 10</th> <th>Date Completed</th> <th>Expiry Date</th> </tr>"; if (isset ($_GET["search"])) { $searchq = $_GET[`search`]; $searchq = ("#[^a-z, A-Z]#i"); if ($result->num_rows > 0) { // output data of each row while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['Applicant_ID'] . "</td>"; echo "<td>" . $row['Firstname'] . "</td>"; echo "<td>" . $row['Lastname'] . "</td>"; echo "<td>" . $row['Address'] . "</td>"; echo "<td>" . $row['DOB'] . "</td>"; echo "<td>" . $row['Telephone_No'] . "</td>"; echo "<td>" . $row['NOK'] . "</td>"; echo "<td>" . $row['NOK_Address'] . "</td>"; echo "<td>" . $row['Vetting_Date'] . "</td>"; echo "<td>" . $row['Clearance_Expiry'] . "</td>"; echo "<td>" . $row['Current_Employer'] . "</td>"; echo "<td>" . $row['Date_applied'] . "</td>"; echo "<td>" . $row['Resubmission'] . "</td>"; echo "<td>" . $row['Number_of_Attempts'] . "</td>"; echo "<td>" . $row['Why'] . "</td>"; echo "<td>" . $row['Qual_1'] . "</td>"; echo "<td>" . $row['Date_Completed_1'] . "</td>"; echo "<td>" . $row['Run_out_date_1'] . "</td>"; echo "<td>" . $row['Qual_2'] . "</td>"; echo "<td>" . $row['Date_Completed_2'] . "</td>"; echo "<td>" . $row['Run_out_date_2'] . "</td>"; echo "<td>" . $row['Qual_3'] . "</td>"; echo "<td>" . $row['Date_Completed_3'] . "</td>"; echo "<td>" . $row['Run_out_date_3'] . "</td>"; echo "<td>" . $row['Qual_4'] . "</td>"; echo "<td>" . $row['Date_Completed_4'] . "</td>"; echo "<td>" . $row['Run_out_date_4'] . "</td>"; echo "<td>" . $row['Qual_5'] . "</td>"; echo "<td>" . $row['Date_Completed_5'] . "</td>"; echo "<td>" . $row['Run_out_date_5'] . "</td>"; echo "<td>" . $row['Qual_6'] . "</td>"; echo "<td>" . $row['Date_Completed_6'] . "</td>"; echo "<td>" . $row['Run_out_date_6'] . "</td>"; echo "<td>" . $row['Qual_7'] . "</td>"; echo "<td>" . $row['Date_Completed_7'] . "</td>"; echo "<td>" . $row['Run_out_date_7'] . "</td>"; echo "<td>" . $row['Qual_8'] . "</td>"; echo "<td>" . $row['Date_Completed_8'] . "</td>"; echo "<td>" . $row['Run_out_date_8'] . "</td>"; echo "<td>" . $row['Qual_9'] . "</td>"; echo "<td>" . $row['Date_Completed_9'] . "</td>"; echo "<td>" . $row['Run_out_date_9'] . "</td>"; echo "<td>" . $row['Qual_10'] . "</td>"; echo "<td>" . $row['Date_Completed_10'] . "</td>"; echo "<td>" . $row['Run_out_date_10'] . "</td>"; echo "</tr>"; } echo "</table>"; } else { echo "0 results"; } } $dbhandle->close(); ?>
  15. Chris721
    thank you for all the help, its getting there. Just need to find out why it won't display the data now.
  16. Chris721
    that gives no errors but no results either
  17. Chris721
    If I search by full name I get You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'leanard OR `Lastname` LIKE adele leanard' at line 1
  18. Chris721
    the query is running but it returns this Unknown column 'Booth' in 'where clause'
  19. Chris721
    I have done that and I am now getting no errors but no posts, the code now looks like this <title>Applicant Data view</title> <p> <center><img src="cyberwarfareimage1.png" alt="Squadron logo" style="width:200px;height:200px" style="middle"></center> <table border="1"> <tr> <td><a href="index.php"> Home Page </a></td> <td><a href="administratorhomepage.html">Administrator Home Page </a></td> <td><a href="viewhomepage.html">View Home Page </a></td> </table> </p> <?php $searchq =($_GET['search']); include "connection.php"; $sql = ("SELECT * FROM applicant WHERE `Firstname` LIKE $searchq OR `Lastname` LIKE $searchq") or die("Could Not Search"); $result = $dbhandle->query($sql); echo "<table border='1'> <tr> <th>Applicant Id</th> <th>Firstame</th> <th>Lastname</th> <th>Address</th> <th>Date Of Birth</th> <th>Contact Number</th> <th>Next Of Kin</th> <th>Next Of Kin Address</th> <th>Vetting Date</th> <th>Clearance Expiry</th> <th>Current Employer</th> <th>Date Applied</th> <th>Resubmitting</th> <th>Number Of Previous Attempts</th> <th>Why</th> <th>Qualificaton 1</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 2</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 3</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 4</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 5</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 6</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 7</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 8</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 9</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 10</th> <th>Date Completed</th> <th>Expiry Date</th> </tr>"; if(isset ($_GET["submit"])) { $searchq = $_GET[`submit`]; $searchq = preg_replace("#[^a-z]#i","",$searchq); if ($result->num_rows > 0) { // output data of each row while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['Applicant_ID'] . "</td>"; echo "<td>" . $row['Firstname'] . "</td>"; echo "<td>" . $row['Lastname'] . "</td>"; echo "<td>" . $row['Address'] . "</td>"; echo "<td>" . $row['DOB'] . "</td>"; echo "<td>" . $row['Telephone_No'] . "</td>"; echo "<td>" . $row['NOK'] . "</td>"; echo "<td>" . $row['NOK_Address'] . "</td>"; echo "<td>" . $row['Vetting_Date'] . "</td>"; echo "<td>" . $row['Clearance_Expiry'] . "</td>"; echo "<td>" . $row['Current_Employer'] . "</td>"; echo "<td>" . $row['Date_applied'] . "</td>"; echo "<td>" . $row['Resubmission'] . "</td>"; echo "<td>" . $row['Number_of_Attempts'] . "</td>"; echo "<td>" . $row['Why'] . "</td>"; echo "<td>" . $row['Qual_1'] . "</td>"; echo "<td>" . $row['Date_Completed_1'] . "</td>"; echo "<td>" . $row['Run_out_date_1'] . "</td>"; echo "<td>" . $row['Qual_2'] . "</td>"; echo "<td>" . $row['Date_Completed_2'] . "</td>"; echo "<td>" . $row['Run_out_date_2'] . "</td>"; echo "<td>" . $row['Qual_3'] . "</td>"; echo "<td>" . $row['Date_Completed_3'] . "</td>"; echo "<td>" . $row['Run_out_date_3'] . "</td>"; echo "<td>" . $row['Qual_4'] . "</td>"; echo "<td>" . $row['Date_Completed_4'] . "</td>"; echo "<td>" . $row['Run_out_date_4'] . "</td>"; echo "<td>" . $row['Qual_5'] . "</td>"; echo "<td>" . $row['Date_Completed_5'] . "</td>"; echo "<td>" . $row['Run_out_date_5'] . "</td>"; echo "<td>" . $row['Qual_6'] . "</td>"; echo "<td>" . $row['Date_Completed_6'] . "</td>"; echo "<td>" . $row['Run_out_date_6'] . "</td>"; echo "<td>" . $row['Qual_7'] . "</td>"; echo "<td>" . $row['Date_Completed_7'] . "</td>"; echo "<td>" . $row['Run_out_date_7'] . "</td>"; echo "<td>" . $row['Qual_8'] . "</td>"; echo "<td>" . $row['Date_Completed_8'] . "</td>"; echo "<td>" . $row['Run_out_date_8'] . "</td>"; echo "<td>" . $row['Qual_9'] . "</td>"; echo "<td>" . $row['Date_Completed_9'] . "</td>"; echo "<td>" . $row['Run_out_date_9'] . "</td>"; echo "<td>" . $row['Qual_10'] . "</td>"; echo "<td>" . $row['Date_Completed_10'] . "</td>"; echo "<td>" . $row['Run_out_date_10'] . "</td>"; echo "</tr>"; } echo "</table>"; } else { echo "0 results"; } } $dbhandle->close(); ?>
  20. Chris721
    I think I may have done the form wrong <form action='search2.php' method='GET'> <center> <h1>Search By Name</h1> <input type='text' size='90' name='search'></br></br> <input type='submit' name='submit' value='Submit' ></br></br></br> </center> </form>
  21. Chris721
    Yes but I am only just starting with php so learning as I go. I have tried the one above before and got another error Notice: Undefined index: Lastname in C:\wamp\www\search2.php on line 14 and Notice: Undefined index: Firstname in C:\wamp\www\search2.php on line 15
  22. Chris721
    I am not sure how to define the $searchq
  23. Chris721
    I am new to php and html, I am trying to make a search function where you can search by a persons firstname or lastname but I am getting an error. the error is Notice: Undefined variable: searchq in C:\wamp\www\search2.php on line 17. Can anyone help me please <title>Applicant Data view</title> <p> <center><img src="cyberwarfareimage1.png" alt="Squadron logo" style="width:200px;height:200px" style="middle"></center> <table border="1"> <tr> <td><a href="index.php"> Home Page </a></td> <td><a href="administratorhomepage.html">Administrator Home Page </a></td> <td><a href="viewhomepage.html">View Home Page </a></td> </table> </p> <?php include "connection.php"; $sql = ("SELECT * FROM applicant WHERE `Firstname` LIKE $searchq OR `Lastname` LIKE $searchq") or die("Could Not Search"); $result = $dbhandle->query($sql); echo "<table border='1'> <tr> <th>Applicant Id</th> <th>Firstame</th> <th>Lastname</th> <th>Address</th> <th>Date Of Birth</th> <th>Contact Number</th> <th>Next Of Kin</th> <th>Next Of Kin Address</th> <th>Vetting Date</th> <th>Clearance Expiry</th> <th>Current Employer</th> <th>Date Applied</th> <th>Resubmitting</th> <th>Number Of Previous Attempts</th> <th>Why</th> <th>Qualificaton 1</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 2</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 3</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 4</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 5</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 6</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 7</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 8</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 9</th> <th>Date Completed</th> <th>Expiry Date</th> <th>Qualificaton 10</th> <th>Date Completed</th> <th>Expiry Date</th> </tr>"; if(isset ($_POST["submit"])) { $searchq = $_POST[`submit`]; $searchq = preg_replace("#[^a-z]#i","",$searchq); if ($result->num_rows > 0) { // output data of each row while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['Applicant_ID'] . "</td>"; echo "<td>" . $row['Firstname'] . "</td>"; echo "<td>" . $row['Lastname'] . "</td>"; echo "<td>" . $row['Address'] . "</td>"; echo "<td>" . $row['DOB'] . "</td>"; echo "<td>" . $row['Telephone_No'] . "</td>"; echo "<td>" . $row['NOK'] . "</td>"; echo "<td>" . $row['NOK_Address'] . "</td>"; echo "<td>" . $row['Vetting_Date'] . "</td>"; echo "<td>" . $row['Clearance_Expiry'] . "</td>"; echo "<td>" . $row['Current_Employer'] . "</td>"; echo "<td>" . $row['Date_applied'] . "</td>"; echo "<td>" . $row['Resubmission'] . "</td>"; echo "<td>" . $row['Number_of_Attempts'] . "</td>"; echo "<td>" . $row['Why'] . "</td>"; echo "<td>" . $row['Qual_1'] . "</td>"; echo "<td>" . $row['Date_Completed_1'] . "</td>"; echo "<td>" . $row['Run_out_date_1'] . "</td>"; echo "<td>" . $row['Qual_2'] . "</td>"; echo "<td>" . $row['Date_Completed_2'] . "</td>"; echo "<td>" . $row['Run_out_date_2'] . "</td>"; echo "<td>" . $row['Qual_3'] . "</td>"; echo "<td>" . $row['Date_Completed_3'] . "</td>"; echo "<td>" . $row['Run_out_date_3'] . "</td>"; echo "<td>" . $row['Qual_4'] . "</td>"; echo "<td>" . $row['Date_Completed_4'] . "</td>"; echo "<td>" . $row['Run_out_date_4'] . "</td>"; echo "<td>" . $row['Qual_5'] . "</td>"; echo "<td>" . $row['Date_Completed_5'] . "</td>"; echo "<td>" . $row['Run_out_date_5'] . "</td>"; echo "<td>" . $row['Qual_6'] . "</td>"; echo "<td>" . $row['Date_Completed_6'] . "</td>"; echo "<td>" . $row['Run_out_date_6'] . "</td>"; echo "<td>" . $row['Qual_7'] . "</td>"; echo "<td>" . $row['Date_Completed_7'] . "</td>"; echo "<td>" . $row['Run_out_date_7'] . "</td>"; echo "<td>" . $row['Qual_8'] . "</td>"; echo "<td>" . $row['Date_Completed_8'] . "</td>"; echo "<td>" . $row['Run_out_date_8'] . "</td>"; echo "<td>" . $row['Qual_9'] . "</td>"; echo "<td>" . $row['Date_Completed_9'] . "</td>"; echo "<td>" . $row['Run_out_date_9'] . "</td>"; echo "<td>" . $row['Qual_10'] . "</td>"; echo "<td>" . $row['Date_Completed_10'] . "</td>"; echo "<td>" . $row['Run_out_date_10'] . "</td>"; echo "</tr>"; } echo "</table>"; } else { echo "0 results"; } } $dbhandle->close(); ?>
×
×
  • 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.