Ad:

PHP Discussion Thread
Unsolved
Views: 802

Oct 7th, 2007

Need Help with converting an ID to a Name

Expand Post »

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:

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.

Similar Threads

converting vrml 1.0 to 2.0 in Computer Science
Converting lowercase to capitals in Java
Converting Excel to Mysql in MySQL
Converting Bytes to MB? in Visual Basic 4 / 5 / 6
converting base class to dervived class in C

jtmcgee

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

13 posts
since Oct 2007

Permalink

Oct 7th, 2007

Re: Need Help with converting an ID to a Name

try this, it might work.

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_row($item_query);
 
			echo"You got an ".$item[0]."!";
 
		}
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]."!";
 
		}

kkeith29

Reputation Points: 235

Solved Threads: 193

Nearly a Posting Virtuoso

Offline

1,315 posts
since Jun 2007

Permalink

Oct 8th, 2007

Re: Need Help with converting an ID to a Name

Quote ...

$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

Quote ...

$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.

johny_d

Reputation Points: 33

Solved Threads: 7

Junior Poster in Training

Offline

92 posts
since May 2007

Permalink

Oct 8th, 2007

Re: Need Help with converting an ID to a Name

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.

kkeith29

Reputation Points: 235

Solved Threads: 193

Nearly a Posting Virtuoso

Offline

1,315 posts
since Jun 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Paging Problem

Next Thread in PHP Forum Timeline: Parse html

DaniWeb Message

Cancel Changes

User Name
Password