Wordpress Calendar from MYSQL data

My name is John Conlin and I am the owner of Contingent Fitness Training. I want to have a wp calendar created from mysql data. Need a wordpress page to display a calendar with values from a database given a userID. This is the Query to get calendar SELECT cft_fitbitheartrateday.activity_date, cft_fitbitheartrateday.heart_zone_type, cft_fitbitheartrateday.heartratezone_id, [login to view URL], cft_fitbitheartrateday.calories_out, cft_fitbitheartratezone.heart_zone_name FROM cft_fitbitheartrateday JOIN cft_fitbitheartratezone ON cft_fitbitheartrateday.heartratezone_id = cft_fitbitheartratezone.heartratezone_id and cft_fitbitheartrateday.user_id = cft_fitbitheartratezone.user_id Where [login to view URL] > 0 and cft_fitbitheartrateday.user_id = :user_id and cft_fitbitheartrateday.activity_date = :activity_date This is an example of pulling the test per day of the calendar [login to view URL]('user_id').AsInteger := UserSession.icft_UserID; [login to view URL]('activity_date').AsDate := ADate; [login to view URL]; While not [login to view URL] Do begin S := [login to view URL]('heart_zone_name').AsString+' '+ [login to view URL]('minutes').AsString+'m'; Calories := [login to view URL]('calories_out').AsInteger; if Calories > 0 then S := S + ' '+Calories.ToString+'cal'; [login to view URL](S); [login to view URL]; end; [login to view URL]; end; Sample Database table information CREATE TABLE `cft_fitbitheartratezone` ( `heartratezone_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` varchar(40) DEFAULT NULL, `heart_zone_type` varchar(1) NOT NULL, `heart_zone_name` varchar(20) NOT NULL, `heart_rate_min` int(11) DEFAULT NULL, `heart_rate_max` int(11) DEFAULT NULL, PRIMARY KEY (`heartratezone_id`), KEY `by_user_zones` (`user_id`,`heart_zone_type`,`heart_zone_name`,`heart_rate_min`,`heart_rate_max`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8; CREATE TABLE `cft_fitbitheartrateday` ( `heartrateday_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `activity_date` date NOT NULL, `heart_zone_type` varchar(1) NOT NULL, `heartratezone_id` bigint(20) unsigned DEFAULT NULL, `minutes` int(11) DEFAULT NULL, `calories_out` double DEFAULT NULL, `entry_ts` datetime DEFAULT NULL, PRIMARY KEY (`heartrateday_id`), KEY `by_user_id_date` (`user_id`,`activity_date`,`heart_zone_type`) ) ENGINE=InnoDB AUTO_INCREMENT=497 DEFAULT CHARSET=utf8; Sample Data at attached The user id should be 30 not 1.