PDA

View Full Version : COUNT > MYSQL



Paho
3rd April 2016, 14: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

IzNoGoD
3rd April 2016, 15:09
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
3rd April 2016, 15:43
thanks, it works now