mySQLi: SELECT con clausola WHERE.

<?php
$servername="localhost";
$username="XXXX";
$password="XXXX";
$database="id3147737_db";

$conn=new mysqli($servername,$username,$password,$database);

if($conn->connect_error){
    die("Connessione non riuscita" . $conn->connect_error);
}

$sql="SELECT * FROM Transazioni WHERE id=2";
$result=$conn->query($sql);
if($result->num_rows >0){
    while($row = $result->fetch_assoc()){
        echo "id: " . $row["id"] . " - nome: " . $row["nome"] . "
";
    }
}else{
    echo "Nessun record trovato";
}
?>

E funziona:

id: 2 - nome: Downloads/abruzzo.png

---