[SOLVED] Setting up a mysql query help

[graham23s]

Hi Guys,

 

i have this query to select disctinct, user id's from mysql, but i have now realised i also need the `date` field assosciated with those fields:

 

<?php
$queryvisitors = "SELECT DISTINCT `visitorsid` FROM `usersvisitors` WHERE `usersid`='$var_loggedinuserid' ORDER BY `date` DESC LIMIT 5";
?>

 

is there away i can select the `date` field in the same query as distinct at all?

 

thanks guys

 

Graham

[Barand]

if you want the date last visited by each visitor

 

SELECT visitorsid, MAX(date) as lastvisit

FROM uservisitors

WHERE `usersid`='$var_loggedinuserid'

GROUP BY visitorsid

ORDER BY lastvisit DESC

LIMIT 5

[graham23s]

Thanks barry i was way off lol.

 

Graham