Subversion Repositories VORC

Rev

Rev 58 | Rev 97 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 58 Rev 65
Line 253... Line 253...
253 
  	$getMe = "select distinct * from $table $whereClause $orderby";
 253 
  	$getMe = "select distinct * from $table $whereClause $orderby";
254 
  } else {
 254 
  } else {
255 
    $curpage = ($curpage - 1) * $pagelimit;
 255 
    $curpage = ($curpage - 1) * $pagelimit;
256 
  	$getMe = "select distinct * from $table $whereClause $orderby limit $curpage, $pagelimit";
 256 
  	$getMe = "select distinct * from $table $whereClause $orderby limit $curpage, $pagelimit";
257 
  }
 257 
  }
258 
	my ($totalcount) = $internalDBH->selectrow_array ("select distinct count(*) from $table $whereClause");
 258 
	my ($totalcount) = @{$internalDBH->selectrow_arrayref ("select distinct count(*) from $table $whereClause")};
Line 259... Line 259...
259 
 
 259 
 
260 
	my $limhan = $internalDBH->prepare($getMe);			# Get the tickets from the DB
 260 
	my $limhan = $internalDBH->prepare($getMe);			# Get the tickets from the DB
Line 261... Line 261...
261 
	$limhan->execute();
 261 
	$limhan->execute();