Maybe if there is a member of this forum that is very conversant with PHP and Perl they will be willing to help direct you, but considering that this is a forum dedicated to Perl the chances are remote at best. I know nothing about PHP and my SQL skills are limited in the extreme, so I can't help you at all. -------------------------------------------------

$dbs[$row[0]] = {}; - that makes it an empty array? an initializer of it..

$dbs{$row[0]}->{props} = [@row]; - now does this fill in the results into an element called props...

if you guys can explain in detail what exactly is going on here, it will help me a lot. :)

There is a lot going on there and explaining it in detail is beyond the scope of this forum. You want to get yourself some perl books or start reading tutorials. Here is a good place to start reading about perl: