You're combining two approaches to retieving data. In order to populate values defined in bind_columns use fetch, when using fetchrow_array DBI returns a list, thus ($pdisplay_order, $parent_name, $child_name) = $sth->fetchrow_array();

Update:Checked the DBI docs, and there is a fully worked example of the use of bind_columns in the section titled bind_columns

rdfield