[C#] Restart Problem

[Nikolee]

A simple question :

 

I make atm a Feature to Bann Player with C# and MySql but i got one Problem.

I need to Read out with the player name the a_index.

 

Also : From a_name to know the a_index.

 

With this is not Working :

 

UPDATE `newproject_db`.`t_characters` SET `a_enable` = 0 WHERE `t_characters`.`a_Name` =Tast; // Thats for Bann with Name

 

And i started with this :

string PlayerId = maskedTextBox1.Text;
string Index = "SELECT * FROM `t_characters` a_index WHERE `a_name` = Niko "; // And how can i Include the string PlayerID ?

But it Always say Unkown Column -.-

I dont know what more i should do tryied so much things .

 

2

 

Only wanna to bann the Player with the Name not with Index..^^ GN8 hope tommorow i got some answers^^