array variable from mysqli php code example

Example: mysqli load result into array

$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'];
		//	}