// see if already subscribed
                $db = \Database::connection('testlogin');
                $result = $db->query("SELECT * FROM subscribed WHERE userID='$userID' and kmzID='$kmzID'");
                if($result) {
                error_log("ihtsnipcart with result: ", 1, "errorlog@interiorhighlandstrails.us");
                    $row = $result->fetchRow();
                    $index = $row['index'];
                } else {
                error_log("ihtsnipcart NO result: ", 1, "errorlog@interiorhighlandstrails.us");
                    $index = 0;
                }
                /*
                $sql = "SELECT * FROM subscribed WHERE userID=$userID and kmzID=$kmzID";
                $result = mysqli_query($con, $sql);
                $row = mysqli_fetch_array($result);
                $index = $row[0];
                //print_r($row);
                //echo "index = ".$index;
                //echo "<br>";
                */
 
                error_log("ihtsnipcart index: ".$index, 1, "errorlog@interiorhighlandstrails.us");
 
                if(!$index) {
                    error_log("ihtsnipcart index: ".$index, 1, "errorlog@interiorhighlandstrails.us");
                    // insert into subscribed DB
                    $db = \Database::connection('testlogin');
                    $db->query("INSERT INTO subscribed (userID, kmzID) VALUES ($userID, $kmzID)");
                    $index = $db->Insert_ID();
                    error_log("ihtsnipcart index: ".$index, 1, "errorlog@interiorhighlandstrails.us");
                    /*
                    $sql = "INSERT INTO subscribed (userID, kmzID) 
                    VALUES ($userID, $kmzID)";
                    if (mysqli_query($con, $sql)) {
                        $index = mysqli_insert_id($con);
                        //echo "New subscribed record created successfully. Last inserted ID is: ". $index;
                        //echo "<br>";
 
                    } else {
                        error_log("ihtsnipcart Insert subscribed error user: ".$username." sql: ".$sql. "<br>". mysqli_error($con), 1, "errorlog@interiorhighlandstrails.us");
                        mysqli_close($con);
                        return false;
                    }
                    */
 
                } else {
                        //echo "Already subscribed";
                        //echo "<br>";
                }