in reply to extract column data
am only getting the first lastname am not getting the reset
That's what selectrow_array does. If you want to select more than one row consider using a different method such as selectall_array.