cvs: php-master-web /manage users.php
| From: | Rasmus Lerdorf | Date: | Sat, 03 May 2003 16:47:17 +0000 |
| Subject: | cvs: php-master-web /manage users.php | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-17256@lists.php.net to get a copy of this message | ||
rasmus Sat May 3 12:47:17 2003 EDT
Modified files:
/php-master-web/manage users.php
Log:
Fix duplicate entries. It was showing a user record for each user note.
The count is still wrong when adding a search pattern. Not sure how to
fix cleanly. Jim?
Index: php-master-web/manage/users.php
diff -u php-master-web/manage/users.php:1.28 php-master-web/manage/users.php:1.29
--- php-master-web/manage/users.php:1.28 Sat May 3 04:53:12 2003
+++ php-master-web/manage/users.php Sat May 3 12:47:17 2003
@@ -283,7 +283,7 @@
or die("query '$query' failed: ".mysql_error());
$total = mysql_result($res,0);
-$query = "SELECT DISTINCT users.userid,cvsaccess,username,name,email,note FROM users LEFT JOIN
users_note USING (userid) $searchby $orderby $limit";
+$query = "SELECT DISTINCT users.userid,cvsaccess,username,name,email,note FROM users LEFT JOIN
users_note USING (userid) $searchby group by userid $orderby $limit";
#echo "<pre>$query</pre>";
$res = mysql_query($query)