get multiple rows

Posted on 16th Feb 2014 07:03 pm by admin

Hi I want to get multiple rows from a db

I am using this for the db query
Code: 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

Code: '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

Your Answer:

Login to answer

Other forums

FTP issues
Hi all,


I am currently facing some serious problems with a script and really need some ad

Images outside webroot
Im hopeing someone can help me with this because i cant figure it out.I have setup an ASP.NET websit

using file_get_contents??
okay how would i create a script using file_get_contents() in php have it grab search pages 1-20 and

Loop column after 2 results
Hello All.

Here is what I have:

Client ID Company name Clien

exclude characters from counting?
Hello, I wanted to ask if you have a string like:
Code: $my_s='ASRGREGTGTR----REGREGRE+++RRRRRR..

Progress bar tracking file downloads
Hey guys, was wondering if there was a way to track how far a file has been downloaded. I know there

how to get different value in second view of webdynpro?
hello guys,

In ABAP webdynpro I am trying to create one application having two views.

While Problem
i am having a problem with a while statement here is the code
Code: [Select]<?php
sess

private constructor
Hello,

Can we create a constructor as private? If yes, what is the use of it? If no, why can'

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne