[BUG] What's wrong with this query

[andreiwow2]

Hey guys, I get the following error:

 

"payphone\main.lua:23: dbPoll failed; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version and for the right syntax to use near 'WHERE Number = 906366 at line 1"

 

This is the code:

local checkNr = dbQuery(handler, "SELECT * FROM PayPhoneOW LIMIT 1 WHERE Number = ".. phonenumber)
			local result, num_affected_rows, last_insert_id = dbPoll ( checkNr, -1 )
			
			outputChatBox(tostring(num_affected_rows))

Fixed... LIMIT 1 was infront of WHERE... sorry....

Edited May 28, 2017 by Dutchman101
Fix topic title for section requirements