connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Query
";
$q = "with pp as (select playid,pname from plays as pl order by rand() limit 1) select pp.pname, speaker, lineinplay, theline from slines as sl inner join pp on pp.playid=sl.pid order by rand() limit 1;";
echo $q;
echo "
Result
";
$result = $conn->query($q);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
foreach( $row as $kk=>$vv ) {
echo " " . $vv;
}
echo "\n";
}
}
else {
echo "Got nothing";
}
?>