MTA SQL register problem

[Weser]

Hello guys i have problem with sql check database does player exist or not 

 

 if(mysql_num_rows(dbQuery(connect, "SELECT id FROM players where username='"..editBox.."'"))) then

  outputChatBox("Not work :(")
 end

but this mysql_num_rows seems not working is there other type to check that or not?

Edited November 21, 2016 by Weser

[LilDawage]

you have problem here you can try with method else

[Weser]

2 hours ago, NightStar said:

you have problem here you can try with method else

what do you mean ?

[pa3ck]

	dbQuery( function(qh)
		local result = dbPoll( qh, 0 )
		if(result and #result > 0) then
			outputChatBox("Found")
		else
			outputChatBox("Not found")
		end
			
	end,connection, "SELECT id FROM players where username= ? LIMIT 1", username )

 

[LilDawage]

1 hour ago, pa3ck said:

	dbQuery( function(qh)
		local result = dbPoll( qh, 0 )
		if(result and #result > 0) then
			outputChatBox("Found")
		else
			outputChatBox("Not found")
		end
			
	end,connection, "SELECT id FROM players where username= ? LIMIT 1", username )

 

right u can use this