Recuperare dati da colonne con lo stesso nome

[badaze]

Boh.

global $mysqli,$db_table_prefix; 
$tabella1 = $db_table_prefix."sell_offer";
$tabella2 = $db_table_prefix."flags";

$stmt = $mysqli->prepare(" 
        SELECT a.flag_id, a.title, b.flag_country, b.gif_name, a.id
        FROM ".$tabella1." a,    ".$tabella2." b 
        WHERE a.flag_id = b.id 
        ");
$stmt->execute();
$stmt->bind_result($id, $title, $flag_country, $gif_name, $id2);
$count = 0;    
while ($stmt->fetch()){
   $row[] = array('id' => $id, 'title' => $title, 'flag_country' =>$flag_country, 'gif_name' => $gif_name,'id2'=>$id2);
   echo "<br>". $row[$count]['id']." - ". $row[$count]['title']." - " . $row[$count]['flag_country']." - ". $row[$count]['gif_name']." - ". $row[$count]['Id2'];
   $count = $count+1;
}
$stmt->close(); 

$row[$count] = array('id' => $id, 'title' => $title, 'flag_country' =>$flag_country, 'gif_name' => $gif_name,'id2'=>$id2);
echo "<br>".$id." - ".$title." - ".$flag_country." - ".$gif_name." - ".$id2 ;