(147) (134) (116) (118) (113) (93) (54) (85) (117) (100) (61) (66) (63) (171) (90) (51) (116)
my ($statement,$handle);
if ($QUERY_VARS{'b'}==1)
{
return 1;
}
elsif ($QUERY_VARS{'b'} eq 'all')
{
$statement = q/SELECT firma.id, firma.short_name FROM firma ORDER BY firma.short_name;/;
$handle = smap::MySQL_exec($db,$statement);
}
else
{
my $f1 = $QUERY_VARS{'b'}*100;
my $f2 = $f1+100-1;
$statement = q/SELECT firma.id, firma.short_name FROM firma,spec WHERE firma.id=spec.id AND spec.spec BETWEEN ? AND ? GROUP BY firma.id ORDER BY firma.short_name;/;
$handle = smap::MySQL_exec($db,$statement,$f1,$f2);
}
?>
 |
|
 |