Number Guessing Game - Build a Number Guessing Game

Makusu · June 3, 2025, 9:01am

Tell us what’s happening:

Every print test is failing, when I play the game the check for existing user works.
I even tried with the automated users created after a test run and they are recognized.
It seems to me that best game and number of tries are also recorded.
I checked for similar questions on the forum therefor I tried to copy the messages again, also tried to change the way TRIES are taken into acount (removed tries where input was incorect)
I don’t understand where the problem lies.

Your code so far

github.com/Makusu-dev/randomNumberGame

number_guess.sh

main

#!/bin/bash

PSQL="psql --username=freecodecamp --dbname=number_guess -t --no-align -c"

MAIN_MENU(){
  echo "Enter your username:"
read username

USERNAME=$($PSQL "SELECT username FROM randomnumbergame WHERE username='$username'") 


if [[ $USERNAME ]]
then
  GAMESPLAYED=$($PSQL "SELECT games_played FROM randomnumbergame WHERE username='$username'") 
  BESTGAME=$($PSQL "SELECT best_game FROM randomnumbergame WHERE username='$username'") 
  echo "Welcome back, $USERNAME! You have played $GAMESPLAYED games, and your best game took $BESTGAME guesses."

else
  echo $($PSQL "INSERT INTO randomnumbergame(username,games_played,best_game) VALUES ('$username',0,1000000) " ) 
  USERNAME=$($PSQL "SELECT username FROM randomnumbergame WHERE username='$username'")

This file has been truncated. show original

Your browser information:

User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:128.0) Gecko/20100101 Firefox/128.0

Challenge Information:

Number Guessing Game - Build a Number Guessing Game

ILM · June 3, 2025, 9:36am

a common mistake is not coutning all guesses, even the invalid ones. Looking quickly at your code it seems you have that issue

Makusu · June 3, 2025, 11:12am

Well that’s the thing I read on another thread that they should not be accounted for so I tried both but nothing seems to work.

Makusu · June 3, 2025, 11:20am

Oh wait I think I got it. I need to count the winning try. So stupid

Topic		Replies	Views
Number Guessing Game - Build a Number Guessing Game Backend Development	12	56	February 28, 2025
Number Guessing Game - Build a Number Guessing Game Backend Development	11	73	April 14, 2025
Problems by number_guessing_game Backend Development	3	42	January 21, 2025
Number Guessing Game - Build a Number Guessing Game Backend Development	3	216	January 7, 2025
Number Guessing Game - Build a Number Guessing Game Backend Development	13	45	April 29, 2025

Number Guessing Game - Build a Number Guessing Game

Tell us what’s happening:

Your code so far

Your browser information:

Challenge Information:

Related topics