PDA

View Full Version : trimming array to one entry per userID


rhuxochi
Sat 9th Feb '02, 4:02pm
I am creating an array from the following:

$data = "SELECT * from data LEFT JOIN users on data.userID=users.userID ORDER BY users.userID, data.dataID Limit 1,25";



and would like to display ONLY on entry per unique userID...anyone????????

Many thanks in advance!