prepare("SELECT joke, ts, uid FROM jokes_jokes WHERE uid <> ? ORDER BY RANDOM()");
$stm->execute(array($_SESSION["uid"]));
if ($row=$stm->fetch()) {
$stm2=$dbh->prepare("SELECT login FROM jokes_users WHERE uid = ?");
$stm2->execute(array($row["uid"]));
if ($row2=$stm2->fetch()) {
echo "
Proposé par " . $row2["login"] .
" le " . date("d/m/Y",$row["ts"]) . "
";
echo $row["joke"];
}
} else {
echo "Désolé, pas de blague pour vous";
}
?>