Paho
3rd April 2016, 13:47
how create a request?
SELECT COUNT(killszom) FROM table WHERE killszom > (SELECT killszom FROM table where login = "username") working in phpMyAdmin but not in game.
sql = "SELECT COUNT(killszom) FROM `table` WHERE `killszom` > SELECT killszom FROM `table` WHERE `login` ='" + self.pers["loginname"] + "'";
mysql_query(level.mysql, sql);
result = mysql_store_result(level.mysql);
row = mysql_fetch_row(result);
self.ebloebanoe=row[0];
self iprintlnbold(self.ebloebanoe); - this crash
SELECT COUNT(killszom) FROM table WHERE killszom > (SELECT killszom FROM table where login = "username") working in phpMyAdmin but not in game.
sql = "SELECT COUNT(killszom) FROM `table` WHERE `killszom` > SELECT killszom FROM `table` WHERE `login` ='" + self.pers["loginname"] + "'";
mysql_query(level.mysql, sql);
result = mysql_store_result(level.mysql);
row = mysql_fetch_row(result);
self.ebloebanoe=row[0];
self iprintlnbold(self.ebloebanoe); - this crash