combining arrays from sql query

Question

i know this have been asked here for many times but i really couldn't figure out how to do this. im getting this from wordpress sql request

$name = $wpdb->get_results("SELECT Chipset FROM gpu", ARRAY_N);

Array
(
    [0] => Array
        (
            [0] => GeForce GTX 670
        )

    [1] => Array
        (
            [0] => fasdasd
        )

    [2] => Array
        (
            [0] => test
        )

    [3] => Array
        (
            [0] => GeForce GTX 670
        )

    [4] => Array
        (
            [0] => GeForce GTX 560 Ti
        )

)

and for price

$price = $wpdb->get_results("SELECT Price FROM gpu", ARRAY_N);

Array
(
    [0] => Array
        (
            [0] => 403
        )

    [1] => Array
        (
            [0] => 50
        )

    [2] => Array
        (
            [0] => 288
        )

    [3] => Array
        (
            [0] => 288
        )

    [4] => Array
        (
            [0] => 288
        )

)

i need to create this format of array

Array
(
    [0] => Array
        (
            [text] => GeForce GTX 670
            [value] => 403 
        )

    [1] => Array
        (
            [text] => fasdasd
            [value] => 50
        )

    [2] => Array
        (
            [text] => test
            [value] => 288
        )

)

If you know how to get results from two columns in one query and work with that array you can. Also i wanna ask you guys if you could recommend me some good learning material where can i learn this type of combining arrays or how to use bunch of foreach's because i can't get my head around this

Ok solution to my problem is to change sql query but i want to know how to combine these arrays anyway for future.

If you know this has been asked here many times, then why post another question instead of searching? — Aleks G
– Aleks G, Commented Apr 8, 2013 at 15:02

Andrew · Accepted Answer · 2013-04-08 15:03:13Z

2

All you need to do is SELECT Chipset, Price FROM gpu to fetch both columns in a single query. Since you're working with Wordpress, a good place to start is just looking through their documentation. It's going to be helpful to get a good grasp on SQL as well. I'd recommend Tizag's MySQL Tutorial for starters.

answered Apr 8, 2013 at 15:03

Andrew

2,16420 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

combining arrays from sql query

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