Re: sql help ?
| From: | w dot w dot w at gmx dot at | Date: | Tue, 18 Jun 2002 19:08:18 +0000 |
| Subject: | Re: sql help ? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-102759@lists.php.net to get a copy of this message | ||
> select * from tracker where day='1' and month=' ".$month." '
> XXX ";
>
> XXX = but donot return values with the same value in the "sess_id" field
>
> what should XXX be ....?
one line for each sess_id
select * from tracker where day='1' and month=' ".$month." ' group by
sess_id;
or one line for each sess_id with only one row:
select * from tracker where count(sess_id)=1 and day='1' and month='
".$month." ' group by sess_id;
michi
--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net