// file patterns.php // // Provide a browsable list of the patterns, sorted by # persons/# clubs, // along with their brief descriptions and a link to the full pattern. // include("dbsetup.php"); // connect to database include("patternsubs.php"); // common functions include("specialText.php"); $patterns = mysql_query("SELECT name, patternid, clubs, passers, briefDesc FROM pattern WHERE deleted=0 ORDER BY passers, clubs, name") or die("SELECT FROM pattern failed: " . mysql_error()); genheader("Browse our passing patterns"); ?>
These patterns are not all created by us. Some are those we find fun, others just interesting or instructive.
How to organize? Obvious methods:
What sort of patterns are you looking for?
It would be nice to have some way to search. ("Give me all 4-person patterns where at least one passer does a simple 3-count")
Could we create a pattern-generation application??
How about a discussion of difficulty rating for a pattern? Length of pattern, complexities included, speed, number of selfs / count, etc. $passers=-2; // initialize counts for the subsets $clubs=-2; $st = new specialText(""); // for the brief description while ($pattern = mysql_fetch_array($patterns)) { // print new subheader if needed if ($clubs != $pattern["clubs"] || $passers != $pattern["passers"]) { $clubs = $pattern["clubs"]; $passers = $pattern["passers"]; printf("
\n", $st->getHTML()); } ?>
Don't forget to check the external sites - there are good passing pages there.
include("copynotice.php"); echo "