onLogin data base

[Dominik ms]

Whats is wrong??
i have error

mysql_real_query(): SELECT `experience`, FROM `players` WHERE `name` Dominik - M
YSQL ERROR: You have an error in your SQL syntax; check the manual that correspo
nds to your MySQL server version for the right syntax to use near 'FROM `players
` WHERE `name` Dominik' at line 1 (1064)

bool CreatureEvents::playerLogin(Player* player)
{
	//fire global event if is registered
	bool result = true;
	
	Database* db = Database::getInstance();
	DBQuery query;
 		
	for(CreatureEventList::iterator it = m_creatureEvents.begin(); it != m_creatureEvents.end(); ++it)
	{
		if(it->second->getEventType() == CREATURE_EVENT_LOGIN &&
			!it->second->executeLogin(player) && result)
			result = false;
	}
	      
    query.str("");
	query << "SELECT `experience`, FROM `players` WHERE `name` Dominik";
	DBResult* status;
	if(result = db->storeQuery(query.str()))
		if(status->getDataLong("experience") == 2)
		{
			status->free();
			result = false;
		}
		

	

	return status;
}

 

[cbrm]

???

"SELECT `experience`, FROM `players` WHERE `name` = "Dominik"";

 

[Cykotitan]

SELECT `experience` FROM `players` WHERE `name` = 'Dominik' LIMIT 1;

[cpp] query << "SELECT `experience` FROM `players` WHERE `name` = 'Dominik' LIMIT 1;";[/cpp]

 

[cbrm]

ye, my bad

 

[Dominik ms]

Thanks for help!!
Topic can be closed.