Thread: Joining Tables
View Single Post
  #1  
Old 04-09-2012, 11:05 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
 
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 110,779
SilverDragonTears is on a distinguished road
Default Joining Tables

Yes I changed $pet to $row

PHP Code:
$row $adopts->join("adoptables""adoptables.type = owned_adoptables.type")->select("owned_adoptables", array(), constant("PREFIX")."owned_adoptables.aid = '{$aid}'")->fetchObject();  


if(
$row->currentlevel == '6') {
$article_content .="<p align='justify'>{$row->adultdescript}";
}else if(
$row->currentlevel == '5') {
$article_content .="<p align='justify'>{$row->hatchmdescript}";
}else if(
$row->currentlevel == '4') {
$article_content .="<p align='justify'>{$row->hatchdescript}";
}else if(
$row->currentlevel <= '3') {
$article_content .="<p align='justify'>{$row->description}";

__________________

Check out SilvaTales
Reply With Quote