mysql DBI

[Tony Bowden]

On Sat, Aug 25, 2001 at 06:18:09PM +0000, Scott McWhirter wrote:
> this is more a 'what would you do' question than anything else. I'm 
> wondering... What's the best way to get back multiple fields in muliple rows 
> from a table. An example would be well appreciated.

Use an abstraction layer, such as the wonderful Class::DBI::mysql -

  package Foo::Tablename;
  __PACKAGE__->set_db('Main', @dbi_connect_info);
  __PACKAGE__->set_up_table('tablename');

  1;

  package main;

  use Class::DBI::mysql;
    
  foreach my $row (Foo::Tablename->search(wibble => 'bar')) {
    print $row->wibble, $row->some_other_column, $row->etc;
  }

Tony

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 232 bytes
Desc: not available
Url : http://mail.pm.org/archives/belfast-pm/attachments/20010825/f2c4864e/attachment.bin