mysql PHP query into array

Question

I have a table called "images" and it has two columns called "id" and "thumb". I want to query all "thumb" values from id "15". Let's say id "15" contains three rows of "thumb" information. This is what I have

        $db = JFactory::getDbo();
        $query = "SELECT * FROM images WHERE id = '15' ORDER BY sort_order DESC";
        $db->setQuery($query);
        $results = $db->loadObjectList();

So now I have $results but when I try to echo them in PHP it doesn't show anything. It says $results is an "array" but I want to display the three values. I would think "echo $results[1];" would she me some data but it didn't show anything. Is there something I am missing here? I know there's something in $results but I am unsure how to display the data.

use print_r($results) to find the structure. You can also use foreach() -> foreach($results as $result){ print_r($result);} — Sean
– Sean, Commented Sep 30, 2014 at 22:56
Check the answer of this question. Btw, assuming id is an integer, please treat it as such: "..where id=15.." — dimi
– dimi, Commented Sep 30, 2014 at 22:58

Kelvin Kehinde Omolumo · Accepted Answer · 2014-09-30 23:59:35Z

0

When a result return by mysql is greater than one, it is return as an array or an object. So when you want to access each row you use while loop to iterate through the array something like this:

    $db = JFactory::getDbo();
    $query = "SELECT * FROM images WHERE id = '15' ORDER BY sort_order DESC";
    $db->setQuery($query);
    while($results = $db->loadObjectList()){
        // echo whatever ; 
    }

Foreach can also be use. It is up to you the programmer to decide which one fits your need.

answered Sep 30, 2014 at 23:59

Kelvin Kehinde Omolumo

1972 silver badges5 bronze badges

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

Collectives™ on Stack Overflow

mysql PHP query into array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related