No, it doesn't quite work. It get's rid of the m and f but's replaces it with nothing. It just shows 'Gender:'
This is what I have:
PHP Code:
$aid = $stmt->fetchColumn();
$adopt = new OwnedAdoptable($aid);
$gender_lookup = $mysidia->db->select("owned_adoptables", array("gender"), "aid = '{$adopt->getAdoptID()}'")->fetchColumn();
if ($gender_lookup == "m") { $gender = "Male"; }
if ($gender_lookup == "f") { $gender = "Female"; }
$cell = new ArrayList;
$cell->add(new Comment("<a href='/myadopts/manage/{$aid}'><img src='{$adopt->getImage()}'></a>"));
$cell->add(new Comment("<b>Name: </b>{$adopt->getName()}"));
$cell->add(new Comment("<b>Gender: </b>{$Gender}"));
$cell->add(new Comment("<b>Clicks: </b>{$adopt->getTotalClicks()}"));
Thanks ~