Running a loop for each mysql query result fields

Question

queryResultArr is the array that olds mysql queries results, let say i have in my table two columns: doc_1_hits and doc_2_hits, but i don't know prior how much docs i have and i want to run a loop like you can see below: queryResultsArr[0].doc_i_hits instead of doc_1_hits.

i tried a: var str = 'doc_'+i+'_hits'; and then queryResultsArr[0].str but nothing..

for(var i = 1; i < 3; i++){
    if(queryResultsArr[0].doc_i_hits > 0 && queryResultsArr[1].doc_i_hits == 0){
        console.log(i);
    }
}

MrTippet · Accepted Answer · 2014-09-12 14:19:30Z

2

I think you could use the array notation and do it like below because they work similar in this case.

var a = 'doc_'+i+'_hits';
queryResultsArr[0][a]

answered Sep 12, 2014 at 14:19

MrTippet

3061 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Running a loop for each mysql query result fields

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related