Need Help with converting an ID to a Name

•

What is DaniWeb IT Discussion Community?

You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 456,534 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,030 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Thread Tools Display Modes

Views: 486 | Replies: 3

•

Join Date: Oct 2007

Posts: 4

Reputation: jtmcgee is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

jtmcgee

Offline

Newbie Poster

Need Help with converting an ID to a Name

Oct 7th, 2007

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
	if( $rand_num <= $chance )
		{
			//$item_id = mysql_query("SELECT `item` FROM `creatures` WHERE id = '$id_creature'");
			$foo =& creature_stats( item, $id_creature );
 
			$item_query = mysql_query("SELECT * FROM items WHERE id = '$foo'") or ('$item_query');
 
			$item = mysql_fetch_array($item_query);
 
			echo"You got an ".$item."!";
 
		}
	if( $rand_num <= $chance )
		{
			//$item_id = mysql_query("SELECT `item` FROM `creatures` WHERE id = '$id_creature'");
			$foo =& creature_stats( item, $id_creature );
			
			$item_query = mysql_query("SELECT * FROM items WHERE id = '$foo'") or ('$item_query');

			$item = mysql_fetch_array($item_query);

			echo"You got an ".$item."!";

		}

Creature Stats Function:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
function &creature_stats($what_stat, $id) 
{
$mysql_query=mysql_query("SELECT * FROM `creatures` WHERE `id` = '$id'");
$info=mysql_fetch_array($mysql_query);
return $info[$what_stat];
}
function &creature_stats($what_stat, $id) 
{
$mysql_query=mysql_query("SELECT * FROM `creatures` WHERE `id` = '$id'");
$info=mysql_fetch_array($mysql_query);
return $info[$what_stat];
}

I need help getting it to echo $item

It justs puts out nothing.

Last edited by jtmcgee : Oct 7th, 2007 at 5:50 pm.

•

Join Date: Jun 2007

Location: Valley Center, Kansas

Posts: 643

Reputation: kkeith29 is on a distinguished road

Rep Power: 3

Solved Threads: 72

kkeith29

Offline

Practically a Master Poster

Re: Need Help with converting an ID to a Name

Oct 7th, 2007

try this, it might work.

Help with Code Tags

(Toggle Plain Text)

if( $rand_num <= $chance )
		{
			$item_id = mysql_query("SELECT `item` FROM `creatures` WHERE id = '$id_creature'");
			$foo =& creature_stats( item, $id_creature );
 
			$item_query = mysql_query("SELECT * FROM items WHERE id = '$foo'") or ('$item_query');
 
			$item = mysql_fetch_row($item_query);
 
			echo"You got an ".$item[0]."!";
 
		}

•

Join Date: May 2007

Location: Bucharest, RO

Posts: 67

Reputation: johny_d is an unknown quantity at this point

Rep Power: 2

Solved Threads: 4

johny_d

Offline

Junior Poster in Training

Re: Need Help with converting an ID to a Name

Oct 8th, 2007

•

$item = mysql_fetch_array($item_query);

means $item is an array an you cannot put an array in an echo statement; this is why you get nothing.
You need to use $item['name_of_mysql_column'] in your "echo...."
You also have a sintax error: in

•

$foo =& creature_stats( item, $id_creature );

since item is a variable, it needs a $ sign in front; this is a very good reason why you get a blank nothing

Last edited by johny_d : Oct 8th, 2007 at 5:39 pm.

Free Classifieds | Cars for Sale | Pets for Sale | Real Estate Classifieds

•

Join Date: Jun 2007

Location: Valley Center, Kansas

Posts: 643

Reputation: kkeith29 is on a distinguished road

Rep Power: 3

Solved Threads: 72

kkeith29

Offline

Practically a Master Poster

Re: Need Help with converting an ID to a Name

Oct 8th, 2007

sorry i overlooked that sintax error. wow i can't believe i missed that. also, before posting the code i did i should of asked the question; "Will the query ever return more than one result?". i figured there would only be one result and my way would work perfectly, but if more than one is returned you would need to use johny_d's way.