cvs: php-master-web /fetch user-notes.php
| From: | jim winstead | Date: | Wed, 21 Nov 2001 01:31:50 +0000 |
| Subject: | cvs: php-master-web /fetch user-notes.php | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-7474@lists.php.net to get a copy of this message | ||
jimw Tue Nov 20 20:31:50 2001 EDT
Modified files:
/php-master-web/fetch user-notes.php
Log:
get rid of some silly code, remove last of 'removed' stuff
Index: php-master-web/fetch/user-notes.php
diff -u php-master-web/fetch/user-notes.php:1.2 php-master-web/fetch/user-notes.php:1.3
--- php-master-web/fetch/user-notes.php:1.2 Tue Nov 20 20:27:37 2001
+++ php-master-web/fetch/user-notes.php Tue Nov 20 20:31:50 2001
@@ -11,14 +11,12 @@
$query = "SELECT DISTINCT id,note.sect,user,note,UNIX_TIMESTAMP(ts) AS ts,";
$query .= "IF(votes=0, 10, rating/votes) AS rate";
-$query .= " FROM note WHERE NOT removed";
+$query .= " FROM note";
$query .= " ORDER BY sect,rate DESC,ts";
$res = @mysql_query($query) or exit;
-while ($row = mysql_fetch_array($res)) {
- # get rid of the ordered fields, we just want the named ones.
- for ($i = count($row) / 2; $i >= 0; $i--) unset($row[$i]);
+while ($row = mysql_fetch_array($res,MYSQL_ASSOC)) {
echo "$row[id]|$row[sect]|$row[rate]|$row[ts]|$row[user]|",
base64_encode(gzcompress($row[note],3)),"\n";
}