MYSQL Register: Check if code or email is available

[Lanibox]

Hey, im making vb.net program with key register form, but I got problem with checking if code or email is available.

 

Here is code I got now.

 

"SELECT * FROM users WHERE code = '" + acc.Text + "' AND password= '" + TextBox4.Text + "'"

 

It should be like

 

If code = available: true then register:true

If email = available: true then register:true

If code = available:true and email = available:false then register:false

If code = available:false and email = available:true then register:false

 

Hope somebody can help with this

[Lanibox]

Nevermind

 

Got allready this working.