Mysql – SQL Ifelse by Group
I have SQL table such as this: TABLE1 STUDENT SCORE SCOREVAL 1 PASS 10 1 MOD1 4 1 MOD2 5 2 MOD1 4 3 MOD2 2 3 MOD2 1 3 MOD1 9 3 ER 1 4 MOD2 10 4 ER…
Javascript – Is there a better way of writing this If statement?
I was working on a JavaScript program, and needed an if statement to assign a value to a variable when a is larger than b. if (a > b) { c = 11; } Is there a better way of…
Javascript – Return statement not printing to console?
When I run the following code, it only prints to the console "Checkpoint X" but not the return statement: function match(player, computer){ console.log(`Player choice is ${player} and computer choice is ${computer}`); if (player === computer){ console.log("Checkpoint 1") return "It's a…
Javascript – How do I count the occurrences of a string within multiple arrays that are part of an object?
I have an exercise that requires me to use a for loop to iterate through the object 'tutorPetTypes' and calculate the collective total number of cats owned by the tutors. Here's my current code. It runs but results in totalCats…
Checking if a .json file is empty in Python gives me JSONDecodeError
I'm currently working on another school project where I have to write to a .json file. As it depends on if the file is empty or not, I have a simple if clause in my code which handles this: json_start…
Regex check a user input string in JavaScript
I have a if statement that checks if the user left the input empty and did not enter the correct pattern (which is essentially a student number). However, it seems when I input a random mash of words and number,…
Javascript – VueJs: show a skeleton loader when the image is loading
I need to check if the image was loaded by the browser and if all data was fetched, then display a content, if not, show <ItemCardSkeleton /> component instead. So if one image is loaded faster than the others, I…
Javascript – How to combine my if statements to one if statement that checks the specified conditions
Hello I am an aspiring coder and have been making a ton of progress on my proof of concept i.e. simple web calculator but I am having trouble with my disableInputFields function. I cannot figure out how to combine my…
rock paper scissors javascript code doesnt work. I made this as my first project and i dont know at all why it doesnt work
function playRound(playerSelection, computerSelection) { if (playerSelection == computerSelection) { console.log("its a tie") } else if (playerSelection == "rock" && computerSelection == "paper") { return "you lose" } else if (playerSelection == "rock" && computerSelection == "scissors") { return "you win"…
Php – Combine elseifs
it might be a stupid question but I am failing to combine some elseifs. I'm sure there must be smarter way. Do you have an idea? <?php $level_ids = leaky_paywall_subscriber_current_level_ids(); if (!empty($level_ids)) { if (in_array(2, $level_ids)) { echo 'DO THIS';…