$resource = $db->query("SELECT * FROM users WHERE userid = '".$userid."'"); while($row = $resource->fetch_array()) { $the_rows[] = $row; } /// later use like: // foreach($the_rows as $row) // { // echo $row['product']; // }