\n"; // print "\n"; print "

Psalms

\n"; print "

Enter 1 - 150:     \n"; print "\n"; print " \n"; print " \n"; print " \n"; print "

\n"; $query = "select chapter,number,verse from {$schema}.psalms ORDER by chapter,number"; $res = mysqli_query($db,$query); $chapter = 0; while ($row = mysqli_fetch_row($res)){ if ($row[0] != $chapter){ if ($chapter > 0) print "Return to top\n"; print " \n"; print " Psalm {$row[0]}\n"; $chapter = $row[0]; } print "{$row[1]} {$row[2]}\n "; } print "

\n"; print "