#!/usr/bin/perl -w use DBI; use Date::Calc qw(Today); use CGI qw(:standard); print "Content-type: text/plain\n\n"; $theDB = DBI ->connect ('DBI:mysql:ecsmedia', 'ecsmedia', 'S3cq8esL') or die("Cannot connect.\n"); ($year,$month,$day) = Today(); $theProduct = param("filename"); $theDate = "$month/$day/".substr($year, -2); $theReferrer = $ENV{'HTTP_REFERER'}; $Query = "SELECT * FROM productCounters WHERE Product='$theProduct' AND Date='$theDate'"; $result = $theDB->prepare($Query) or die("error preparing SQL\n"); $result->execute() or die("error executing SQL\n"); if (@row = $result->fetchrow_array) { $newCount = $row[2] + 1; $newReferrer = $row[3].",".$theReferrer; $Query = "UPDATE productCounters SET Count=$newCount, Referrers='$newReferrer' WHERE Product='$theProduct' AND Date='$theDate'"; $theDB->do($Query) or die("Invalid update"); } else{ $Query = "INSERT INTO productCounters (Product, Date, Count, Referrers) VALUES ('$theProduct','$theDate','1','$theReferrer')"; $theDB->do($Query) or die("Invalid insert"); } $result->finish(); $theDB->disconnect();
Keyboard Kapers
 

SYMBOL SIMON
Helen Smith Tarchalski

Symbol Simon has two colorful games to help players learn to identify music symbols and match with definitions while helping to develop reasoning skills and memory. The first game is Invention Island in which the player must help master Musical Symbol Sleuth, Simon, gather clues called SEAcrets. Answer clue questions in order to gain sand dollars and bonus pearls. The second game is Hatch Match which relies not only on knowledge but memory. Symbols and their definitions must be matched. This program includes a complete reference area and score keeping, and coordinates with popular teaching methods level one and two.

 

Windows CD-ROM: 1483CD
Single Station Price: $39.95
Lab Pack (5 stations) Price: $140.00
Site/Network License (24 stations) Price: $320.00
System requirements: Windows 98, 2000, XP

Download Windows Demo