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);