cvs: php-gtk-web /include shared-manual.inc /manual browse.php
[email protected] ("Colin Viebrock") Fri, 10 Aug 2001 19:29:11 -0000
| Newsgroups | php.gtk |
|---|---|
| Message-ID | <cvscmv997471751@cvsserver> |
cmv Fri Aug 10 15:29:11 2001 EDT
Modified files:
/php-gtk-web/include shared-manual.inc
/php-gtk-web/manual browse.php
Log:
Index: php-gtk-web/include/shared-manual.inc
diff -u php-gtk-web/include/shared-manual.inc:1.20 php-gtk-web/include/shared-manual.inc:1.21
--- php-gtk-web/include/shared-manual.inc:1.20 Fri Aug 10 15:25:21 2001
+++ php-gtk-web/include/shared-manual.inc Fri Aug 10 15:29:11 2001
@@ -233,6 +233,7 @@
$user = 'nobody';
$pass = '';
$db_id = @mysql_pconnect($host, $user, $pass);
+
$query = "SELECT *, UNIX_TIMESTAMP(ts) AS xwhen, IF(votes=0, 0, rating/votes) AS rate FROM note " .
"WHERE sect='$title' OR sect='$id' ORDER BY rate DESC, id";
Index: php-gtk-web/manual/browse.php
diff -u php-gtk-web/manual/browse.php:1.5 php-gtk-web/manual/browse.php:1.6
--- php-gtk-web/manual/browse.php:1.5 Fri Aug 10 15:23:39 2001
+++ php-gtk-web/manual/browse.php Fri Aug 10 15:29:11 2001
@@ -39,8 +39,9 @@
echo '<table border="0" cellpadding="4" cellspacing="0" width="100%">';
-$query = "SELECT *, UNIX_TIMESTAMP(ts) AS xwhen, if(votes=0, 0, rating/votes) AS rate FROM note " .
- "WHERE sect='$title' OR sect='$id' ORDER BY rate DESC, id";
+$query = "SELECT *, UNIX_TIMESTAMP(ts) AS xwhen, IF(votes=0, 0, rating/votes) AS rate FROM note " .
+ "WHERE sect LIKE '%$let' ORDER BY sect, rate DESC, id";
+
$result = mysql_query($query) or die(mysql_error());
$numrows = mysql_num_rows($result);