Mysidia Adoptables Support Forum - More fetching from tables help

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)

- Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)

- - More fetching from tables help (http://www.mysidiaadoptables.com/forum/showthread.php?t=3650)

More fetching from tables help

This snippet of code is suppose to get the names of the parents and show them. As it is now... it shows nothing. I can get it to show the id of the parents, but I'd like it to show their names.

Code:

$result = $adopts->select("owned_adoptables", array(), "aid='{$id}'");

        while ($row = $result->fetchObject()) {

$father=$row->father;

$mother=$row->mother;



$getFather = $adopts->select("owned_adoptables", array(), "aid='{$father}'");

                         

$getMother = $adopts->select("owned_adoptables", array(), "aid='{$mother}'");

$nFather = $row->getFather;

$nFather = $nFather['name'];

$nMother = $row->getMother;

$nMother = $nMother['name'];

if(empty($row->father)) {

    $article_content .= '<b>Caught On:';

} else {

    $article_content .= '<b>Laid On:';

     

}



$article_content .= "{$row->date}<br>";







if($father == '' && $nMother == '') {

    $article_content .= '';

} else {

    $article_content .= 'Father: ' . $nFather . '<br> 

                  Mother: ' . $nMother . '<br>';

    

}



}

First, grab the object instance of the result.

PHP Code:


		
			
$getFather = $adopts->select("owned_adoptables", array(), "aid='{$father}'")->fetchObject();

Then simply fetch the property that stores the name.

PHP Code:


		
			
$getFather->name;

Code:

$result = $adopts->select("owned_adoptables", array(), "aid='{$id}'");

        while ($row = $result->fetchObject()) {

$father=$row->father;

$mother=$row->mother;



$getFather = $adopts->select("owned_adoptables", array(), "aid='{$father}'")->fetchObject();

$getFather->name;    

                         

$getMother = $adopts->select("owned_adoptables", array("name"), "aid='{$mother}'");

$nFather = $nFather['name'];

$nMother = $row->getMother;

$nMother = $nMother['name'];





if($father == '' && $nMother == '') {

    $article_content .= '';

} else {

    $article_content .= 'Father: <a href="levelup.php?id='.$father.'">' . $getfather . '</a><br> 

                  Mother: ' . $nMother . '<br>';

Somehow I didn't do it right :/

It's like this

PHP Code:


		
			
$article_content .= 'Father: <a href="levelup.php?id='.$father.'">' . $getFather->name . '</a><br>.....';

You the MAN!!! Thank you :D