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:

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:

	$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

              //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 -

".$name."

 

[SieghartZeke]

AHH....BUT I GET SOME DISASTER WHEN I ADD!I SO NOOB!