Changing the funciton of a button?

[trajik]

Check if your query with ' instead of ` will work.

I don't understand...

[50p]

mysql_query( connect_mysql, "SELECT * FROM 'players' WHERE charName='" .. getPlayerName( theUser ) .. "'" )
or even
mysql_query( connect_mysql, "SELECT * FROM players WHERE charName='" .. getPlayerName( theUser ) .. "'" )

[dzek (varez)]

wtf?

MySQL query with single quote -> ' around table name?

This "weird single quote" -> ` its for surrounding table/column names (not needed, until your table/column name is same as one mysql reserved words, like "date", "table", "create", etc)

And normal single quote -> ' its for surrounding values.

SELECT * FROM 'aaa' LIMIT 0, 30

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''aaa' LIMIT 0 , 30' at line 1

[trajik]

yeah still not what I'm looking for...in a nutshell this is what I mean

function changeTheButtons()
local query = (look for the players account name)
if (query) then
while true
local find =(look back at the players account name and see if they have a character)
if(find) then
spawnCharacter()
else
createCharacter()
end
end
freeResults.....ect.
end

I know it's not real code....but that's what I mean and what I need.

[dzek (varez)]

Dump your database, using any software for MySQL, but in SQL code (CREATE TABLE ... etc), not in the way as above.

And:

I removed your "bump". Do not bump your post. Especially when there are no others topics waiting for reply, and when only 2 hours passed. Also do not double,triple,quadruple,multi post. I will remove all your bumps in the future. Thank you for understanding