SELECCIONA FILES I LES MOSTRA

$conn     = mysqli_connect($host, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
// Select row from table
$sql = "SELECT * FROM english_castilian WHERE catala LIKE 'table' ";
//$sql    = "SELECT * FROM english_castilian WHERE id >= 10000 limit 10";
$result = mysqli_query($conn, $sql); //resultat
// Fetch rows and print them
while ($row = mysqli_fetch_assoc($result)) {
    echo $row['catala'] . "---" . $row['castella'];
    echo "<br>";
}
// Close connection
mysqli_close($conn);

?>

BUSCAR UN NOM I MOSTRAR-LO

$conn     = mysqli_connect($host, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
// Select row from table
$sql = "SELECT * FROM english_castilian WHERE catala LIKE 'table' ";
//$sql    = "SELECT * FROM english_castilian WHERE id >= 10000 limit 10";
$result = mysqli_query($conn, $sql); //resultat
// Fetch rows and print them
while ($row = mysqli_fetch_assoc($result)) {
    echo $row['catala'] . "---" . $row['castella'];
    echo "<br>";
}
// Close connection
mysqli_close($conn);