sub generate_offer_index {

$dbh = $mysql->connect_to_db;

$numrec = $dbh->selectrow_array("SELECT COUNT(*) FROM ata_offers");

my $query = qq|SELECT M.name, O.offer_start, O.offer_end, O.offer, O.icon, O.additional FROM ata_members AS M, ata_offers AS O WHERE M.id=O.id|;
$sth = $dbh->prepare($query);
$sth->execute or die("Can't execute SQL query:<BR><BR>[$DBI::err] $DBI::errstr");

while (my $ref = $sth->fetchrow_hashref())
{

$offer_data .= qq|<tr bgcolor="#F4EFF7">
<td class="text-black" width="25%">$ref->{'name'}</td>
<td class="text-black" width="57%">$ref->{'offer'}</td>
<td class="text-black" width="18%">$ref->{'offer_end'}</td>
</tr>
|;
}

$sth->finish;
$dbh->disconnect;

}