count Questions

Javascript – Iterate through an object and count all strings containing specific text within each and all arrays

August 2, 2023
TheFall1976
2 Answers

I have an object containing arrays, I want to count the number of occurrences a particular string is found across all arrays in the object. const festivals = { 'Danny': ['Glastonbury','Glastonbury','Leeds','Leeds','Leeds','Benicassim','MadCool'], 'Jimbo': ['Glastonbury','Glastonbury','Leeds','Leeds','Leeds','Leeds','Benicassim','MadCool'], 'Richard': ['Glastonbury','Leeds','Leeds','Benicassim','MadCool'], 'John': ['Glastonbury','Leeds'] } let totalFestivals…

VIEW QUESTION

Postgresql – Join and group by based on a value of a column to filter

VIEW QUESTION

MySql count with GROUP BY returns 1 even when count is 0

June 3, 2023
Kabilan S
2 Answers

I have two tables in MySql i.e., subjects and photos and I wished to count the number of photos on each subjects SELECT a.id, a.name, count(a.id) as `refcount`, FROM `subjects` a LEFT JOIN `photos` b ON (a.id = b.subject_id) GROUP…

VIEW QUESTION

Postgresql – How to combine two counts on one table?

May 22, 2023
Blue Sulley
2 Answers

The table is like: country fruit size Japan Apple Big Japan Apple Small Japan Orange Big Singapore Banana Small The expect output is like: country type total Japan 2 3 Singapore 1 1 I managed to run the counts separately.…

VIEW QUESTION

Javascript – How to remove specific words that are repeated and add a word (if possible) to string

May 22, 2023
Diego
2 Answers

How to remove specific words on a string (and add the word "and" if possible) that are repeated twice but only twice and only certain characters? Example: "Intruction in seated LE AROM x10 each instruction in standing LE AROM x10…

VIEW QUESTION

“How do I count all posts from a CPT in WordPress?”

May 17, 2023
Seby
3 Answers

My wordpress real estate theme have a custom post type for properties. Statuses in backend: All, Mine, Published, Draft, Disabled by user I have a custom field (prop) and I am trying to autocomplete it when a new post is…

VIEW QUESTION

Is there a way to increment count by 1 when it’s a multiple of 2 in Javascript?

May 16, 2023
A P I
2 Answers

How can I increase the value stored in count by one every time it is a multiple of 2 I have a function that returns the value of i, it is initialized to 0 and it is auto-incrementing, that is,…

VIEW QUESTION

How do I show the count of checked checkboxes using vanilla JavaScript?

May 16, 2023
flexbeatz
2 Answers

Im currently working on a website that generates a random password. One part of it shows the safety of the current password. Until now i was only able to make the safety-indicator dependent on the current length of the password.…

VIEW QUESTION

How many posts in the last 7 days from a taxonomy.php page in WordPress?

May 14, 2023
George
2 Answers

On my taxonomy archive page, I display terms and child terms of the queried taxonomy. I also want to echo the number of posts associated with each child term. The code below works fine, BUT I want to count only…

VIEW QUESTION

Not sure whats wrong in the below Query of the problem "Biggest Single Number" from leetcoode – Mysql

April 29, 2023
Kiran Kutte
4 Answers

A single number is a number that appeared only once in the MyNumbers table. Write an SQL query to report the largest single number. If there is no single number, report null. The query result format is in the following…

VIEW QUESTION