· 7 years ago · Sep 03, 2018, 04:38 AM
1PHP mysqli returns wrong columns
2$sql = "SELECT * FROM players";
3$result = $conn->query($sql);
4while( $row = $result->fetch_assoc() ){
5 do something
6}
7
8DROP TABLE IF EXISTS `asrleague`.`players`;
9CREATE TABLE `asrleague`.`players` (
10 `player_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
11 `kgs_handle` varchar(40) NOT NULL,
12 `class_id` int(10) unsigned NOT NULL,
13 PRIMARY KEY (`player_id`)
14) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
15
16<b>Warning</b>: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: Headers and client library minor version mismatch. Headers:50145 Library:50018 in ...