Combine Row value of mysql table to array value

Question

I have a table with 6 column. I want the row selected values to access as array values. below is my query

$currentActiveBingoCard = $wpdb->get_results("SELECT id FROM wp_kkfl_bingo_numbers where activate_status =1");

I have below mysql table which I want all 5 numbers in array.

Please suggest.

Please edit your question and paste all relevant information there, noone wants to scroll through the comments to get what you're after. Also hard to read in the comments. — user8034901
– user8034901, Commented Nov 25, 2019 at 7:36

Slava · Accepted Answer · 2019-11-25 11:41:11Z

1

If you want to join all number fields as one string with values separated by comma you can do it with MySQL CONCAT function:

SELECT CONCAT(number1, ',', number2, ',', number3, ',', number4, ',', number5) as joinedValues FROM `wp_kkfl_bingo_numbers` where activate_status=1

answered Nov 25, 2019 at 11:41

Slava

9486 silver badges9 bronze badges

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

1 Comment

Amol Bhandari SJ Over a year ago

this is the perfect solution. thanks. ill update with this line of code.

Amol Bhandari SJ · Accepted Answer · 2019-11-25 08:43:54Z

1

I got answer to my question after spending sometime.Hope this will help others.

$getBingoScoreboards = $wpdb->get_results("SELECT number1,number2,number3,number4,number5 FROM `wp_kkfl_bingo_numbers` where activate_status=1",ARRAY_N );

$joinedValues =  implode(",",$getBingoScoreboards[0]);

answered Nov 25, 2019 at 8:43

Amol Bhandari SJ

2782 silver badges15 bronze badges

Collectives™ on Stack Overflow

Combine Row value of mysql table to array value

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related