MySQL Forums
Forum List  »  PHP

Re: Problem with query results
Posted by: Bob Cillo
Date: August 05, 2014 01:38PM

Here's the table.

(Field, Type, Collation, Null, Key, Default, Extra, Privileges, Comment) VALUES
('Id', 'int(11)', NULL, 'NO', 'PRI', NULL, 'auto_increment', 'select,insert,update,references', ''),
('TEAM', 'varchar(15)', 'utf8_unicode_ci', 'NO', '', NULL, '', 'select,insert,update,references', ''),
('NAME', 'varchar(50)', 'utf8_unicode_ci', 'NO', '', NULL, '', 'select,insert,update,references', ''),
('OFFICERID', 'varchar(5)', 'utf8_unicode_ci', 'NO', '', NULL, '', 'select,insert,update,references', ''),
('DATE_REPORT', 'varchar(25)', 'utf8_unicode_ci', 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TIMESTAMP', 'timestamp', NULL, 'NO', '', 'CURRENT_TIMESTAMP', 'on update CURRENT_TIMESTAMP', 'select,insert,update,references', ''),
('MONTH', 'varchar(15)', 'utf8_unicode_ci', 'NO', '', NULL, '', 'select,insert,update,references', ''),
('YEAR', 'varchar(5)', 'utf8_unicode_ci', 'NO', '', NULL, '', 'select,insert,update,references', ''),
('CALLS_FOR_SERVICE', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('MISCELLANEOUS_REPORTS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('COLLISION_REPORTS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('INCIDENT_REPORTS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('FIELD_INTERVIEW_REPORTS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('ONLINE_TRAFFIC_COMPLAINTS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TOTAL_ALL_REPORTS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TIME_ON_REPORTS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('WALK_THROUGHS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TOTAL_TIME_ON_CALLS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TIME_COLLISION', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('BUSINESS_CHECKS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TARGETED_BUSINESS_CHECKS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TOTAL_SECURITY', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('HOUSE_CHECKS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('BUSINESS_DRIVEBYS', 'decimal(10,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('RESIDENTIAL_DRIVEBYS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('BUSINESS_SECURITY', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TIME_ON_ADMIN', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TIME_DIRECTED_PATROL', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TIME_FOLLOWUP_INVESTIGATIONS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TIME_IN_TRAINING', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TIME_IN_COURT', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TIME_PATHPATROL', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TIME_ATVPATROL', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TIME_BIKEPATROL', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TIME_DBCHECKS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TIME_WALK_TALK', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('DUI_CHARGES', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TRAFFIC_ENFORCEMENT', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('SI_ARRESTS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('SERVICE_ARRESTS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('WARRANTS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('CITATIONS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('WARNINGS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TOTAL_TRAFFIC', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('VGCSA_CHARGES', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('ORDINANCE_CHARGES', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('MIP_CHARGES', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('PARKING_CHARGES', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('PATH_VIOLATIONS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('GOLFCART_VIOLATIONS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('COURT_APPEARANCES', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('TIME_ON_CALL', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('PATH_PATROL', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('COLLISION_INVESTIGATIONS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('COMMUNITY_RELATIONS', 'decimal(15,0)', NULL, 'NO', '', NULL, '', 'select,insert,update,references', ''),
('MILES_DRIVEN', 'varchar(15)', 'utf8_unicode_ci', 'NO', '', NULL, '', 'select,insert,update,references', ''),
('DAYS_WORKED', 'varchar(15)', 'utf8_unicode_ci', 'NO', '', NULL, '', 'select,insert,update,references', ''),
('time_on_cases', 'varchar(5)', 'utf8_unicode_ci', 'NO', '', NULL, '', 'select,insert,update,references', ''),
('violation_carts', 'varchar(5)', 'utf8_unicode_ci', 'NO', '', NULL, '', 'select,insert,update,references', ''),
('directed_residential', 'varchar(5)', 'utf8_unicode_ci', 'NO', '', NULL, '', 'select,insert,update,references', ''),
('directed_traffic_enforcement', 'varchar(5)', 'utf8_unicode_ci', 'NO', '', NULL, '', 'select,insert,update,references', ''),
('moving_citation', 'varchar(15)', 'utf8_unicode_ci', 'NO', '', NULL, '', 'select,insert,update,references', ''),
('non_moving_citation', 'varchar(15)', 'utf8_unicode_ci', 'NO', '', NULL, '', 'select,insert,update,references', ''),
('citations_path', 'varchar(15)', 'utf8_unicode_ci', 'NO', '', NULL, '', 'select,insert,update,references', ''),
('warnings_path', 'varchar(15)', 'utf8_unicode_ci', 'NO', '', NULL, '', 'select,insert,update,references', '')

Options: ReplyQuote


Subject
Written By
Posted
August 05, 2014 10:09AM
Re: Problem with query results
August 05, 2014 01:38PM
August 06, 2014 08:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.