SELECCIONA FILES I LES MOSTRA
[php]

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

?>

[/php]

BUSCAR UN NOM I MOSTRAR-LO

[php]

$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);
[/php]