Mysql – It seems like my function is only receiving the first char of a string when being called

I am building a basic registration feature for a school project and keep getting an error when I try to check the username and password from a database. The idea is to have a user type in their login info and then have a function receive that information and compare it with the user info from the database. if it matches it will retrieve the user id from the table and attach it to a variable for later use. I am having an issue now where it seems like when I pass in the user input into the password match function, the function only receives the first char of the input. That’s what the debugger shows. I may be reading the debugger wrong but I am not sure here is the first function

void loginUser(){
    
    char email[100];
    char password[50];

    // Input login details
    printf("Enter email: ");
    fgets(email, sizeof(email), stdin);
    email[strcspn(email, "n")] = ''; // Remove newline character
    printf("Enter password: ");
    fgets(password, sizeof(password), stdin);
    password[strcspn(password, "n")] = ''; // Remove newline character
        
    printf("Email: %sn", email);

    printf("Email: %sn", password);

    // Check email and password against database
    if(password_match(email, password)){
        printf("Success");
    };

    // If authenticated, proceed to main menu
    // Else, show error message and redirect to login
};

and this is the function that gets the username and password from mysql database

int password_match(const char *email, const char *password) {

//    printf("Email: %sn", email);

//     printf("Email: %sn", password);

    MYSQL_RES *result;
    MYSQL_ROW row;
    char query[512];
    snprintf(query, sizeof(query), "SELECT consumerID FROM CurrentConsumer WHERE email='%s' AND password='%s'", email, password);
    
    if (mysql_query(con, query)) {
        fprintf(stderr, "Error querying database: %sn", mysql_error(con));
        return 0; // Failure
    }
    
    result = mysql_store_result(con);
    if (result == NULL) {
        fprintf(stderr, "Error storing result: %sn", mysql_error(con));
        return 0; // Failure
    }
    
    row = mysql_fetch_row(result);
    if (row == NULL) {
        mysql_free_result(result);
        return 0; // No match
    }
    
    // Print the consumer ID
    printf("Consumer ID: %sn", row[0]);
    
    mysql_free_result(result);
    return 1; // Match
}

I tried using both pass by value and pass by reference but cant get it to work. It’s weird because I have another function that inserts data into the database just fine. I used that to build this function but cant get it to work.