MySQL result array into session variable

Question

I have a simple MySQL query, I've checked the query in phpmyadmin and it returns 2 results.

I would like to put the result straight into a session variable which should be fairly easy, i have the code below and i only get the first result.

 $row = mysql_fetch_assoc($get_data);

 $_SESSION['data'] = $row;

In my head, this should put the result set into the $row variable, but it doesn't contain all the data. Would i need to wrap it in a loop?

Keyne Viana · Accepted Answer · 2015-12-16 13:46:12Z

2

Each time you call mysql_fetch_assoc it returns one row.

while($row = mysql_fetch_assoc($get_data)) {
    $_SESSION['data'][] = $row;  
}

answered Dec 16, 2015 at 13:46

Keyne Viana

6,2022 gold badges27 silver badges59 bronze badges

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

1 Answer 1