[SOLVED] php return multiple rows

[Miko]

Hello,

 

I have this object here :

 

 class getIDs
{

	function list_MainCat(){

		$sql = "SELECT * FROM MAIN_CAT ORDER BY main_cat_id ASC";
		$query = mysql_query($sql);

		while($row = mysql_fetch_array($query)){

			$maincat[] = $row['main_cat_id'];
			$maincat[] = $row['main_cat_name'];

		}

		return($maincat);

	}

}

 

this object is in a file called 'core.php'.

 

as you can see there is a loop inside, what I would like to do is to echo out the $maincat in another php file.

So I did this in another php file:

 

	$listmaincat = new getIDs();

list($maincat_id,$maincat_name) = $listmaincat->list_MainCat();
        echo $maincat_id." ".$maincat_name;	

 

but of course, it only echoes out 1 record.

 

Anyone knows how I can fix this?

[wildteen88]

This

$maincat[] = $row['main_cat_id'];
          $maincat[] = $row['main_cat_name'];

Should be just

$maincat[] = $row;

 

Now to display your results you'll want to loop through them, eg

$listmaincat = new getIDs();

foreach($listmaincat->list_MainCat() as $maincat)
{
    echo $maincat['main_cat_id'] . ' ' . $maincat['main_cat_name'] .'<br />';
}

[Miko]

hi, thanks for your reply!

 

it works like this