diff options
| author | Stephan Poehlsen <stephan@poehlsen.net> | 2007-08-14 18:08:19 +0000 |
|---|---|---|
| committer | Stephan Poehlsen <stephan@poehlsen.net> | 2007-08-14 18:08:19 +0000 |
| commit | dac1084f318dc1d0c5c0004448caf236ea673d51 (patch) | |
| tree | 9fad0da9340b7584c7cf637f47df557121dbaf94 /www/index.php | |
| parent | f8fd5c63e0508998b739d8557a22a2889dd866ee (diff) | |
git-svn-id: file:///home/lennart/svn/public/sse/trunk@82 5fbabb74-0606-0410-a5e4-b5cc6a42724e
Diffstat (limited to 'www/index.php')
| -rw-r--r-- | www/index.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/www/index.php b/www/index.php index b62c80e..0cc24b3 100644 --- a/www/index.php +++ b/www/index.php @@ -125,7 +125,7 @@ while ($q) { } - $sql = "SELECT SQL_CALC_FOUND_ROWS COUNT(*)/COUNT(DISTINCT pr.id) AS keywords_cnt, ". + $sql = "SELECT COUNT(*)/COUNT(DISTINCT pr.id) AS keywords_cnt, ". " SUM(w.cnt)/COUNT(DISTINCT pr.id) AS cnt, " . " f.path, f.language_id, pr.id AS prid, pr.name AS package_name ". " FROM word AS w, file AS f, package AS p, provider_record AS pr ". @@ -155,7 +155,7 @@ while (isset($sql) and $sql) { break; } - $res2 = mysql_query("SELECT FOUND_ROWS() AS cnt"); + $res2 = mysql_query("SELECT COUNT(*) AS cnt FROM word AS w WHERE ".$where); if ($r2 = mysql_fetch_array($res2)) { $total = $r2['cnt']; } @@ -182,7 +182,7 @@ $max_start = ($max_page-1)*$num; if ($total) { - echo('<p>Results: <span id="results_total">'.$total."</span></p>\n". + echo('<p>Results: ca. <span id="results_total">'.$total."</span></p>\n". '<ul class="results" id="result_list">'."\n"); while ($r = mysql_fetch_array($res)) { @@ -219,7 +219,7 @@ if ($max_page > 1) { } echo(($start < $max_start ? '<li><a id="browse_next" href="'.$l.min($max_start, $start+$num).'">next</a>'."</li>\n" : ''). - ($start < $max_start ? '<li><a id="browse_last" href="'.$l.$max_start.'">last</a>'."</li>\n" : ''). + //($start < $max_start ? '<li><a id="browse_last" href="'.$l.$max_start.'">last</a>'."</li>\n" : ''). "</ul>\n"); } |