[nick1200]

I have tried two Google this be for i posted on here but couldn't find nothing


i am doing a select two get there users pokemon id

		$sql = "SELECT * FROM user_pokemon WHERE username='$_SESSION[username]'";
$result = mysql_query($sql) or die(mysql_error());
$battle_get = mysql_fetch_array($result);

 echo $battle_get['pok1']; 

This works fine and prints it out
but now i wanna match there poke1 id up with the id of the pokemon in the main pokemon table

$sql1 = "SELECT pokeID FROM pokemon WHERE pokeID=='$battle_get['pok1']'";
$result1 = mysql_query($sql) or die(mysql_error());
$battle_get111 = mysql_fetch_array($result);


 echo $battle_get11['pokeID']; 

Why don't this work ? i think i need two post the data into the were ?

[no2pencil]

It doesn't work because of the variable array in the where statement. The single quotes for the array are interfering with the single quotes marking the where value. Just remove them from the array.

$sql1 = "SELECT pokeID FROM pokemon WHERE pokeID='$battle_get[pok1]'";
$result1 = mysql_query($sql) or die(mysql_error());
$battle_get111 = mysql_fetch_array($result);

You only need them if your array name has a space. Also the double equals was wrong...

[ShaneK]

Didn't you say you'd stop posting here a long time ago?

Anyway, you don't use logical equal signs in MySQL. Also, reading your query makes my eyes hurt because of the lack of separation.

Yours,
Shane~

[nick1200]

no2pencil, on 30 June 2010 - 03:47 AM, said:

It doesn't work because of the variable array in the where statement. The single quotes for the array are interfering with the single quotes marking the where value. Just remove them from the array.

$sql1 = "SELECT pokeID FROM pokemon WHERE pokeID='$battle_get[pok1]'";
$result1 = mysql_query($sql) or die(mysql_error());
$battle_get111 = mysql_fetch_array($result);

You only need them if your array name has a space. Also the double equals was wrong...

well it is only showing the first echo and not the second

$sql1 = "SELECT pokeID FROM pokemon WHERE pokeID=='$battle_get[pok1]'";
	$result1 = mysql_query($sql) or die(mysql_error());
	$battle_get111 = mysql_fetch_array($result);

 echo $battle_get111['pokeID']; 

That's what i got for the second that should echo out the pokeID ?

[Dormilich]

your SQL beats any logic, why would you get the exact same field, that you use in the WHERE clause? you wouldn’t need the SQL at all (unless you fetch more data).

your SQL is susceptible to SQL Injection.

I recommend using a JOIN, so you can directly query the main table with the user name.

# this involves some guessing on my side since I don’t know the table structures
SELECT pm.pokeID FROM pokemon AS pm JOIN user_pokemon AS upm ON upm.pok1 = pm.pokeID AND upm.username = ?

This post has been edited by Dormilich: 30 June 2010 - 04:53 AM

[ShaneK]

Your first code might work, but that doesn't mean it's right. His code would have fixed its structure and its problem. Once again, you DO NOT use logical equal signs in MySQL.

Use:

Quote

=

NOT:

Quote

==

Yours,
Shane~

[nick1200]

i just wanna get the pok1 id from the user_pokemon table

then match it with the pokeID from the pokemon table two get what pokemon they got etc ...

		$sql = "SELECT * FROM user_pokemon WHERE username='$_SESSION[username]'";
$result = mysql_query($sql) or die(mysql_error());
$battle_get = mysql_fetch_array($result);

 echo $battle_get['pok1']; 
 

$sql1 = "SELECT * FROM pokemon WHERE pokeID=='$battle_get[pok1]'";
	$result1 = mysql_query($sql) or die(mysql_error());
	$battle_get111 = mysql_fetch_array($result);

 echo $battle_get111['pokeNAME']; 

ive edited it a bit but the 2nd sql ent working any resosn why ?? no white page or nothing tho

This post has been edited by nick1200: 30 June 2010 - 05:11 AM

[ShaneK]

Did you even try to change your code?
I seriously doubt it. Like always you just want somebody to do your work for you. They even did and it doesn't even look like you attempted to give it a shot.

I wish you stayed away like you said you would.

Yours,
Shane~

[no2pencil]

For the life of me, I don't know what is so difficult about reading & then using copy & paste for the suggested code.

You always do this, you post a question, along with example code, we show you what's wrong & you insist on using the code that we explain why it's wrong.

nick1200, on 30 June 2010 - 05:56 AM, said:

Don't worry i new this was the wrong place two post

We can't fix stupid.

You ask, we answer, you don't do as we suggest. Not our fault.

Also it's "to", not "two".

[CTphpnwb]

...and it's "knew", not "new", as well as "want to", not "wanna", but who's counting?

Nick, you need to pay attention to what you're doing, and especially to the advice you're given. Your poor grammar/spelling is just the tip of the iceberg.