<php>

   $sFileDb = "/home/httpd/vhosts/laure-marc.ch/httpdocs/conf/concours.sql3";
   $oDb = new SQLite3($sFileDb, 0666, $sErr);

if ($sErr) exit($sErr);

$sSql = “SELECT name, sexe FROM pronostics”;

$oQuery = $oDb->query($sSql);

while($aRow = $oQuery->fetchArray(SQLITE3_ASSOC)){ 
    $aRows[] = $aRow;
};

print “<table>”;

print “<tr><th>Nom</th><th>Pari</th></tr>”;

foreach ($aRows as $aRow) {

print "<tr><td>".$aRow['name']."</td><td>".$aRow['sexe']."</td></tr>";

} print “</table>”; </php>