Two operations to do: doing filter from Table1 displaying on Table2

Hello !

Why it is not working I think the issue is here: $_POST['valueToSearch']

that means someone must type the name and must click the button and I don't see any logic to read names from Table1 automatically
or remember which name is current and switch every 5 sec.

So instead, try to use PHP to get the current name from Table1 and JS to refresh every 5 sec with the next name and a prepared statement instead of this:

$query = "SELECT * FROM india_company WHERE name = '".$valueToSearch."'";

here is my solution you can adjust it for your need of course :

= count($names)) {
    $index = 0;
}

$currentName = count($names) > 0 ? $names[$index] : "";

// here you get the records from Table2 filtered by current name
$dataResult = false;
if ($currentName !== "") {
    $stmt = mysqli_prepare($connect, "SELECT * FROM india_company WHERE name = ?");
    mysqli_stmt_bind_param($stmt, "s", $currentName);
    mysqli_stmt_execute($stmt);
    $dataResult = mysqli_stmt_get_result($stmt);
}


$nextIndex = ($index + 1) % count($names);
?>




    
    
    



Currently filtering by: 

 0): ?>
        

    

        
ID
        
Name
        
Company
        
City
    

    
            

                

                

                

                

            
        
    
        

            
No records found