Jump to content

Notice: Undefined variable: searchq in C:\wamp\www\search2.php on line 17


Chris721
Go to solution Solved by hansford,

Recommended Posts

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(); 

?>

Link to comment
Share on other sites

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
Link to comment
Share on other sites

I am not sure how to define the $searchq

 

It looks like you have a form being filled out before the Applicant Data View page is shown. What does the form code look like?

 

Basically, I'm wondering what the search field is named. You just take the corresponding $_POST variable and assign it to $searchq. Of course, you need to assign the value to the variable prior to the query that uses the variable.

Link to comment
Share on other sites

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>
Link to comment
Share on other sites

Your form uses the GET method. You need to change it to POST...or use $_GET variables in lines like the following:

if(isset ($_POST["submit"])) {

To use the search input in the query, you need to do something like this prior to the query:

$searchq = trim($_GET['search']);

...or if you use the POST method:

$searchq = trim($_POST['search']);
Link to comment
Share on other sites

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(); 
?>
Link to comment
Share on other sites

Have you tried seeing if there is any MySQL errors? Note that you can find out more information about doing that here:

http://php.net/manual/en/mysqli.error.php

 

Basically, you would do something like this:

$sql = ("SELECT * FROM applicant WHERE `Firstname` LIKE $searchq OR `Lastname` LIKE $searchq")  or die("Could Not Search");
$result = $dbhandle->query($sql) or die($dbhandle->error);
 
Once you get the query working, you'll want to get rid of the "or die..." debugging part.
Link to comment
Share on other sites

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(); 
?>
Edited by Chris721
Link to comment
Share on other sites

The following if test isn't needed:

if ($result->num_rows > 0) {

mysqli_fetch_array() returns NULL if there are no results. If it's NULL, the loop content will be skipped.

 

Also, you can avoid the extra overhead of mysqli_fetch_array() since you only use the associative array version of the data. You can use mysqli_fetch_assoc() instead.

 

 

 

Perhaps the following will work:

while($row = $result->fetch_assoc()) {

Note that I switch the code to use the object-oriented version. I'm not sure if that's causing the issue.

Link to comment
Share on other sites

You're using the grave accent in the following line:

$searchq = $_GET[`search`];

You need to use straight quotes:

$searchq = $_GET['search'];

With that said, the following lines aren't really doing anything:

$searchq = $_GET[`search`];
$searchq = ("#[^a-z, A-Z]#i");

I would imagine these lines need to happen before the query where the $searchq variable is used. For now, I would just comment them out until you get the script working. Especially since the second line is going to just overwrite your variable.

 

The second line looks like an attempt to do a regular expression. If you want to get it working, you'll need to look into how they are executed.

Link to comment
Share on other sites


 
<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(); 
?>

Edited by Chris721
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.