check mysql column lua

[amosth 9]

I have a column and in that column I need to check 0 or 1,

 

column "verify" 0 or 1

 

quest testserver begin
	state start begin
		state start begin
			when login or begin
				set_state( gotoinfomation )
			end
		end
		state gotoinfomation begin
			when letter begin
				send_letter("Welcome")
			end
			when button or info begin
				say("text")
				say("")
				local f = select("Yes count","No count")
				if f == 1 then
				local res1, verify = mysql_direct_query("select * from account.account;")
				mysql_direct_query("SELECT verify FROM account.account WHERE verify = '0'")
				else
				say("text2")
				if f == 2 then
				return
				end
				--set_state( gototeacher )
				--end
			end
		end
	end
end

 

[amosth 9]

up