How to show the name of adoptable in the profile page?

[SieghartZeke]

Someone know how to add in the profile page a feature that you can show the name of the other adoptable?

[Xius]

Something like this?
http://pokemonepiphany.com/pokepals/levelup.php?id=90

[SieghartZeke]

Yes...

[Xius]

Just use the ".$name." variable!

[SieghartZeke]

Ehm....where???

[Xius]

Wherever you want, you just have to pull it from the database first, and most pages already do that.

[gabeki]

Really? I can just put $name? O:

I did this:

PHP Code:

function getcurrentname($id){

include("config.php");

$query = "SELECT * FROM ".$prefix."owned_adoptables WHERE aid='$id'";
$result = mysql_query($query);
$num = mysql_numrows($result);

//Loop out code
$i=0;
while ($i < 1) {
 
$currentname=@mysql_result($result,$i,"name"); 

$i++;
}

return $currentname;
} 


added that to function.php

and this to every page I wanted to show the name:

PHP Code:

    $query = "SELECT * FROM ".$prefix."owned_adoptables WHERE owner = '".$user."'";
$aid=@mysql_result($result,$i,"aid");
$nameofpet = getcurrentname($aid); 


and then I use $nameofpet, to show the name

I'm so dumb D:

[Xius]

Yeah. xD

PHP Code:

              //The adoptable's ID
              $aid = @mysql_result($result, $i, "aid");
              $currentlevel = @mysql_result($result, $i, "currentlevel");
              $type = @mysql_result($result, $i, "type");
              $name = @mysql_result($result, $i, "name"); 


That's just an example of what it is in the myadopts.php page.
Just pull the name from the database.

[SieghartZeke]

But...when i add $name i cant show the name of my chaarcter in myadopt page!

[Xius]

You have to include the whole thing -

PHP Code:

".$name."