That doesn't look right, even after fixing the syntax error. Since you call $sth -> fetchrow_array () until it returns an empty list, the last assignment will be the equivalent of:

@{$hall_details {$hall_id}} {qw [ ... ]} = ();
[download]

Effectively wiping out the content the OP was interested in.

Abigail