Little query problem..
Posted: Sat Mar 05, 2005 2:35 pm
Code: Select all
$result = $db->sql("SELECT * FROM `freepicks`
WHERE `date` >= '". $fc->FirstSecond() ."' AND `date` < '". $fc->FirstSecondDay(1) ."'
GROUP BY `uid`
ORDER BY `date` ASC");$fc->FirstSecordDay(1) returns first second of tommorow
Now the problem is I only want the first row of each GROUP BY `uid`.
So I only want to find for each `uid` the guys first `freepicks` of today (only 1 pick per person).
Any thoughts?