Hello thanks to all who helped. I guess I skipped over the section on limiting has_many in the docs. That was what I needed. Some of you have asked for the make up of my tables and which database I'm using.

Database: mysql 4.0.21 Tables: 
CREATE TABLE areas (
  id int(11) NOT NULL auto_increment,
  short_name varchar(10) NOT NULL default '',
  long_name varchar(200) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY short_name (short_name)
) TYPE=MyISAM;

CREATE TABLE stats (
  id bigint(20) unsigned NOT NULL auto_increment,
  aid int(11) NOT NULL default '0',
  uid int(11) NOT NULL default '0',
  login_name varchar(15) NOT NULL default '',
  full_name varchar(50) NOT NULL default '',
  cpu int(11) NOT NULL default '0',
  mem int(11) NOT NULL default '0',
  conn int(11) NOT NULL default '0',
  disk_blocks bigint(20) NOT NULL default '0',
  procs int(11) NOT NULL default '0',
  sess int(11) NOT NULL default '0',
  month int(11) NOT NULL default '0',
  year year(4) NOT NULL default '2004',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

[download]

Again, thank you for your help.

rlb3

In reply to Re^4: Finer points of Class::DBI by rlb3
in thread Finer points of Class::DBI by rlb3

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.