COUNT > MYSQL

[Paho]

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

[IzNoGoD]

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?

[Paho]

thanks, it works now