> 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
