===== Test dance count =====
http://ottawaenglishdance.org/playford/p-dance/dancecounter.php
$wgDBserver = "localhost";
$wgDBname = "playford";
$wgDBuser = "playford";
$wgDBpassword = "pw4playford";
$wgDBport = "5432";
$wgDBprefix = "pf";
$dbcnx = @mysql_connect($wgDBserver, $wgDBuser, $wgDBpassword) or die (mysql_error());
@mysql_select_db($wgDBname);
if (!$dbcnx)
{
die("Could not connect to $wgDBserver: " . mysql_error());
}
mysql_select_db("my_db", $dbcnx);
$result = mysql_query("SELECT * FROM `pfpage` WHERE `page_title` LIKE '%INS:%'");
$numdance = 0;
while($row = mysql_fetch_array($result))
{
/*
echo $row[['page_title']];
echo "
";
*/
$numdance++;
}
echo ("# = $numdance
\
");
mysql_close($dbcnx);
?>