· 6 years ago · Jul 03, 2019, 07:22 AM
1CREATE TABLE IF NOT EXISTS `statistic` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `id_user` int(11) NOT NULL,
4 `id_org` int(11) NOT NULL,
5 `id_driver` int(11) NOT NULL,
6 `coins` int(11) NOT NULL,
7 `data` bigint(20) NOT NULL,
8 UNIQUE KEY `id` (`id`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=20110 ;
10
11$result = $connection->query("SELECT * FROM statistic WHERE `id_user`=".$users[$i]['id']);