# get the category ID we wanna use...
my $CatID = shift;

print "Checking for category $CatID<BR>";

my $banner;

# grab the stuff form the database...
my $table = $DB->table('CatAdverts');
$table->select_options ("ORDER BY RAND()",'LIMIT 1');
my $sth = $table->select( GT::SQL::Condition->new('Categories', 'LIKE', "% $CatID %") );

SetID Title URL Categories
1 Test Title http://www.google.com 1 2 3 4 7 9 11
2 Test Title 2 http://www.google.com 1 2 3 4 7 9 11
3 test again http://www.google.com 3 4 1 2

SetID CatID
1 1
1 3
1 5
1 7
1 9
1 11

my ($banner, $sth2, $table2, $cond);

# grab the stuff form the database...
$table2 = $DB->table('CatAdvertsIDs');
$table2->select_options ("ORDER BY RAND()");
$sth2 = $table2->select( GT::SQL::Condition->new('SetID', '=', 4) );


# only do this if we actually got a result from above...
my $id_got;
if ($sth2) {
while (my $hit = $sth2->fetchrow_hashref) {

$id_got = $hit->{ID}; # get the advert ID...
print "here"; # $hit->{ID} is the category ID...
}
}

# grab the stuff form the database...
$table2 = $DB->table('CatAdvertsIDs');
$table2->select_options ("ORDER BY RAND()","LIMIT 1");
$sth2 = $table2->select( { SetID => 4 } );

# only do this if we actually got a result from above...
my $id_got;
if ($sth2) {
while (my $hit = $sth2->fetchrow_hashref) {
print $hit->{ID}; # get the advert ID...
}
}