❔ SQL Statement only returning one row
Only chest press gets returned, where as I need both





username is not a user-inputted string, it's not SQL injectionSQL injection (SQLi) is a web security vulnerability that allows an attacker to interfere with the queries that an application makes to its database. This can allow an attacker to view data that they are not normally able to retrieve. This might include data that belongs to other users, or any other data that the application can access. In many cases, an attacker can modify or delete this data, causing persistent changes to the application's content or behavior.
In some situations, an attacker can escalate a SQL injection attack to compromise the underlying server or other back-end infrastructure. It can also enable them to perform denial-of-service attacks.
CustomExercises tableDatabaseUtils.ReadData is a black box that none of us know anything aboutreader.Read() advances the reader to the next row in the result, you aren't calling it in a loop
if shouldn't be thereList<object>List<T> ReadData<T>(string query, Func<DbDataReader, T> rowReader) if you want to keep it reusableusernameCustomExercisesDatabaseUtils.ReadDatareader.Read()List<object>List<T> ReadData<T>(string query, Func<DbDataReader, T> rowReader)SELECT * FROM CustomExercisesSELECT Exercise FROM CustomExercisesSELECT Exercise
FROM CustomExercises