cvs: php-gtk-web /include shared-manual.inc
[email protected] ("Colin Viebrock") Fri, 10 Aug 2001 19:25:21 -0000
| Newsgroups | php.gtk |
|---|---|
| Message-ID | <cvscmv997471521@cvsserver> |
cmv Fri Aug 10 15:25:21 2001 EDT
Modified files:
/php-gtk-web/include shared-manual.inc
Log:
grr
Index: php-gtk-web/include/shared-manual.inc
diff -u php-gtk-web/include/shared-manual.inc:1.19 php-gtk-web/include/shared-manual.inc:1.20
--- php-gtk-web/include/shared-manual.inc:1.19 Fri Aug 10 15:23:38 2001
+++ php-gtk-web/include/shared-manual.inc Fri Aug 10 15:25:21 2001
@@ -233,9 +233,11 @@
$user = 'nobody';
$pass = '';
$db_id = @mysql_pconnect($host, $user, $pass);
-# $query = "SELECT *, UNIX_TIMESTAMP(ts) AS xwhen FROM note WHERE sect = '$title' OR sect = '$id' ORDER BY id";
- $query = "SELECT *, UNIX_TIMESTAMP(ts) AS xwhen, if(votes=0, 0, rating/votes) AS rate FROM note " .
+ $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";
+
+ echo "<!-- $query -->\n";
+
if ($db_id) {
$result_id = mysql_db_query("gtk", $query, $db_id);
}