PHP alone cannot do this because PHP runs only once per request.

To automatically change the filter every 5 seconds, you must use JavaScript (AJAX) along with PHP.

The idea is:

1. Get all names from Table1 (year = 2026)

2. Use JavaScript to loop through them

3. Send each name to PHP using AJAX

4. Display filtered results

5. Wait 5 seconds

6. Move to the next name

7. Stop when finished.

8. Step 1 – Create get_names.php

   This file returns names from Table1 as JSON.

   ---

   Step 2 – Modify page_of_table2.php

   This file will receive a name and return filtered results.

   prepare("SELECT * FROM india_company WHERE name = ?");
       $stmt->bind_param("s", $name);
       $stmt->execute();
   
       $result = $stmt->get_result();
   
       while($row = mysqli_fetch_assoc($result)) {
           echo $row['name'] . " - " . $row['company'] . "
   ";
       }
   }
   ?>
   

   (Note: Prepared statements are used to prevent SQL injection.)

   ---

   Step 3 – Create the Main Page (Auto Filter Page)

   
   
   
       
   
   
   
   Filtered Results
   
   
   
   
   
   
   

   ---

   What This Does

   If Table1 contains:

   • steve

   • kalamah

   • anderson

   The page will:

   • Show results for steve

   • Wait 5 seconds

   • Show results for kalamah

   • Wait 5 seconds

   • Show results for anderson

   • Stop automatically

   No manual typing required.

Hello Israel,

you can use this code and give a try,

connect_error) {
    die("Connection failed: " . $connect->connect_error);
}

// Get all names from Table1 (year 2026)
$nameQuery = $connect->prepare("SELECT name FROM table1 WHERE year = ?");
$year = 2026;
$nameQuery->bind_param("i", $year);
$nameQuery->execute();
$nameResult = $nameQuery->get_result();

$names = [];
while ($row = $nameResult->fetch_assoc()) {
    $names[] = $row['name'];
}

// AJAX request to fetch filtered data
if(isset($_GET['name'])) {

    $filterQuery = $connect->prepare("SELECT * FROM india_company WHERE name = ?");
    $filterQuery->bind_param("s", $_GET['name']);
    $filterQuery->execute();
    $result = $filterQuery->get_result();

    while($row = $result->fetch_assoc()) {
        echo "";
        echo "".$row['id']."";
        echo "".$row['name']."";
        echo "".$row['year']."";
        echo "";
    }
    exit;
}
?>




    



Auto Filtering Table Every 5 Seconds


    

        

            
ID
            
Name
            
Year