Page 1 of 1

var_dump returns bool(false)

Posted: Sat Nov 07, 2009 9:32 pm
by psychotomus
don't know what i'm doing wrong here.

game_id = 2
all my fields are right in the query
anybody see a problem?

Code: Select all

$game_id = mysql_real_escape_string($_GET['id']);
 
//retreive game data
$result = mysql_query("SELECT game_data.name, game_data.platform_id, game_consoles.console FROM game_data, game_consoles WHERE game_consoles.id='game_data.platform_id' AND game_data.id='$game_id'") or die(mysql_error());
$game_data = mysql_fetch_assoc($result);
 
var_dump($game_data);

Re: var_dump returns bool(false)

Posted: Sat Nov 07, 2009 10:11 pm
by requinix

Code: Select all

game_consoles.id='game_data.platform_id'
'game_data.platform_id' is a string. Because you put quotes around it. What you want to use are backticks:

Code: Select all

game_consoles.id=`game_data`.`platform_id`

Re: var_dump returns bool(false)

Posted: Sun Nov 08, 2009 4:29 am
by psychotomus
'game_data.platform_id' is an integer

Re: var_dump returns bool(false)

Posted: Sun Nov 08, 2009 5:25 am
by requinix
psychotomus wrote:'game_data.platform_id' is an integer
No. I'm talking about inside the SQL:

game_data.platform_id is an integer.
'game_data.platform_id' is a string.
"game_data.platform_id" is a string.
`game_data`.`platform_id` is an integer.