Hi everybody I've been using DBI for a while now, having made some large programs utilising a mysql db, and all have been successful. But I've come across one project now that may be a little more taxing on my knowledge of DBI. All the while I've been using DBI, I've been getting data by column reference, i.e
@data = $sth->fetchrow_array; $name = $data[1]; $email = $data[2]; ..so on and so forth.. but the project I'm currently writing sees a drastically changing database as it's developed. With writing the web interface in PHP, I don't have to worry about changing the physical layout of the tables, as it retrieves the data by column name. However I'm unable to find any reference to Perl being able to do the same thing? I've looked briefly at hashref, but I don't quite understand it all. First off, is this even possible? If so, can anyone point me in the right direction as to how to figure it out, or provide me a few lines of sample code I can learn off? Many thanks, Dan -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>