Re: cvs: php-master-web /manage users.php
| From: | Rasmus Lerdorf | Date: | Sat, 03 May 2003 17:15:14 +0000 |
| Subject: | Re: cvs: php-master-web /manage users.php | ||
| References: | 1 | Groups: | php.mirrors |
| Request: | Send a blank email to php-mirrors+get-17258@lists.php.net to get a copy of this message | ||
On Sat, 3 May 2003, Derick Rethans wrote:
> On Sat, 3 May 2003, Rasmus Lerdorf wrote:
>
> > 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?
>
> Add the notes in a seperate table and link to it... normalization? :)
The notes are already in a separate table. The problem is that the left
join and the match() stuff mess up the group by clause.