var_dump returns bool(false)

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
psychotomus
Forum Contributor
Posts: 487
Joined: Fri Jul 11, 2003 1:59 am

var_dump returns bool(false)

Post 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);
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: var_dump returns bool(false)

Post 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`
Last edited by requinix on Sun Nov 08, 2009 5:24 am, edited 1 time in total.
psychotomus
Forum Contributor
Posts: 487
Joined: Fri Jul 11, 2003 1:59 am

Re: var_dump returns bool(false)

Post by psychotomus »

'game_data.platform_id' is an integer
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: var_dump returns bool(false)

Post 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.
Post Reply