How to get multiple rows from a database request

Question

This is what I have so far. It calls to the database and receives one comment and all of the values that go with it, but I want to get multiple comments with the same id. How do I set up a array to get the multiple comments?

function get_comment_by_id($lake_id) {

        global $connection;
        $query = "SELECT * ";
        $query .= "FROM comments ";
        $query .= "WHERE lakeId=" . $lake_id ." ";
        //$query .= "LIMIT 1";
        $result_set = mysql_query($query, $connection);
        confirm_query($result_set);

        // REMEMBER:
        // if no rows are returned, fetch_array will return false
        if ($comment = mysql_fetch_array($result_set)) {
            return $comment;
        } else {
            return NULL;
        }
    }

DiverseAndRemote.com · Accepted Answer · 2012-12-20 18:54:16Z

2

you just need to put it in a while loop. instead of

if ($comment = mysql_fetch_array($result_set)) {
    return $comment;
} else {
    return NULL;
}

do

$rows = array();
while($comment = mysqli_fetch_array($result_set))
    $rows[] = $comment;

return $rows;

and you also need to use mysqli_* functions since the mysql_* functions are deprecacted.

In the calling function you should check for an empty array instead of a null value

edited Dec 20, 2012 at 18:54

answered Dec 20, 2012 at 18:48

DiverseAndRemote.com

20k10 gold badges65 silver badges75 bronze badges

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

4 Comments

DiverseAndRemote.com Over a year ago

no problem, if it answers you question just hit the check mark to select it

user1551909 Over a year ago

now I have this error: mysqli_query() expects parameter 1 to be mysqli, string given

DiverseAndRemote.com Over a year ago

see stackoverflow.com/questions/10160664/…

DiverseAndRemote.com Over a year ago

you need to be consistent with your use of mysqli functions

Collectives™ on Stack Overflow

How to get multiple rows from a database request

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related