Select Code to Download

servers_tbl
-----------
...
 drv_letter           (text)
 total_disk_size      (number)
 free_space_remaining (number)

# lookup the server id
my $server_id = LookupServerID($srv);

$perms_db->Sql ("INSERT INTO $drives_tbl (server_id,drv_letter,total_d
+isk_size,free_space_remaining) VALUES ( $server_id, '$drv_letter', $t
+otal_disk_size,$free_space_remaining)");

sub LookupServerID
{
...
    #  run the sql through your $perms_db and return the id
    #  you'll probably want to cache these values later...
}