-
COUNT > MYSQL
how create a request?
PHP Code:
SELECT COUNT(killszom) FROM table WHERE killszom > (SELECT killszom FROM table where login = "username")
working in phpMyAdmin but not in game.
PHP Code:
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
-
add () around your subquery in cod, just like you did in phpadmin.
Why do you think a query works in phpmyadmin allows you to remove some braces?
-