get multiple rows

[teknojunkey]

Hi I want to get multiple rows from a db

 

I am using this for the db query

	public function getCeleb($product_id) {

	$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_to_celeb WHERE product_id = '" . (int)$product_id . "'");


	foreach ($query->rows as $result) {
		$celeb_id = $result['celeb_id'];
	}

	return $celeb_id;
}

 

and this to display the returned data

 

'celeb_id' => $result['celeb_id']
print_r ($celeb_id);

 

the problem is i only get one result from the database and i have multiple entries with the same id

 

thanks in advance

 

[shorty3]

u need to add $i++; at the end and ,$i in the brackets

[teknojunkey]

can you explain for stupid please

[PFMaBiSmAd]

The line of code $celeb_id = $result['celeb_id']; is overwriting $celeb_id each pass through the foreach() loop. You only get the last value out. If you want an array of all the values, you need to build an array -

 

$celeb_id[] = $result['celeb_id'];