Joining Tables

[SilverDragonTears]

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}";
} 


[Hall of Famer]

Well the problem may be with the $aid in the where clause. As I said before, this was just a rough example. It assumes that your adoptables id are stored in variable $aid, if the variable name is not $aid, or that you aint using adoptables id to fetch information, you will need to modify the where clause.

[SilverDragonTears]

What should I change it to? I'm lost about it..

Edit: I don't give myself enough credit...

constant("PREFIX")."owned_adoptables.aid = '{$id}'")

That worked. I have another issue... Should I make a new thread? Dragons won't show up in siggies

[Hall of Famer]

Oh dragons wont show up in siggy? The same adoptables id problem? Check if you get rid of is_numeric() from every php page. XD

[SilverDragonTears]

Don't I just need to make sure it's not in siggy.php? Which I did...

[Hall of Famer]

I do not have this problem from the demo site, nor do I have trouble using bbcodes from TOD.

[SilverDragonTears]

Test:



What on earth....

[Hall of Famer]

So you see? Its not a problem at all. XD

[SilverDragonTears]

LoL... I must be tired!

[Hall of Famer]

Alright guess thats it, I understand the frustration of having to start over when you already have a community with 500 members and 2500 posts. You must be overexhausted, take a rest now if you have to. XD