Hallo Johanna,
versuch's mal so:
$sql = "SELECT id, name FROM $table_name";
$result = mysql_query($sql)or die($db_error);
$i=0;
while($data = mysql_fetch_assoc($result)){
$foobar[$i]['id']=$data['id'];
$foobar[$i]['name']=$data['name'];
$i++;
}
print_r ($foobar);
Dieter