my $cgi=CGI->new(); $index=int($cgi->param('index') || -1); my $query=" ... FROM ... BY index"; if($index!=-1) { $query.=" WHERE index < ? COUNT 10"; } else { $query.=" COUNT 10"; }