Unity C# MySQL Issues

I'm kind of unclear on what you want to do. Do you need the number of rows that the result returns? If so, you should probably read in all the results into a generic or something similar.

Also, it looks like you are trying to see if a username exists or not, so what I would first check off is that your Username field on your rz_users table is unique. Then, you could just see if the query returns 0 results to check if the username exists. That is, a simple if statement checking if the query results are null.

yeaaah do you think you could help me write that query check?

Sure. I've done something similar. Just basically run the SqlDataReader or whatever you are using, and check if the query is null. Could you clarify a bit on what doQuery is? Is this a method you've written yourself? I've never seen it.

doQuery was what the guy SixTimesNothing wrote,

 // $$anonymous$$ySQL Query
 
     public static void doQuery(string sqlQuery) {
 
         IDbCommand dbCommand = dbConnection.CreateCommand();
 
         dbCommand.CommandText = sqlQuery;
 
         IDataReader reader = dbCommand.ExecuteReader();
 
         reader.Close();
 
         reader = null;
 
         dbCommand.Dispose();
 
         dbCommand = null;
 
     }

but i figured you could probably do the same without calling it so i started to change $$anonymous$$e to look more like this

 public bool ValidInformation(string User, string Pass)
     {
         string query = "SELECT ID FRO$$anonymous$$ rz_users WHERE Username = " + User +" AND Password = " + Pass;
         
         IDbCommand dbCommand = dbConnection.CreateCommand();
         dbCommand.CommandText = query;
         IDataReader reader = dbCommand.ExecuteReader();
         
         
         return true;
         reader.Close();
         reader = null;
         dbCommand.Dispose();
         dbCommand = null;
     }

Thanks for all the help you've been giving

Okay, now what you need to do is make the Username field unique so only one value can occupy it in your table. Then, check if the DataReader is null. If so, it will not have received the data. You can do this by checking the HasRows property. I believe IDataReader has this property (or something similar), but I'd recommend using SqlDataReader if you don't have to use IDataReader.

 if (dataReader.HasRows)
 {
     // There is data in the query. 
     // Since the Username is unique, 
     // you don't have to worry about more than one.
 }
 else
 {
     Debug.Log("No user with username: " + username);
 }