PDA

View Full Version : MySql Select Distinct not working?


Fatman
05-12-2003, 11:20 AM
Im using the following statement but still getting duplicate Parents - help?

Select DISTINCT codeForum.Parent, Title, Post, Username from codeForum inner join codeUser on codeForum.User = codeUser.ID where User=1 order by DatePosted DESC LIMIT 5

Fatman
05-13-2003, 11:29 AM
its ok - i used group[ by instead :)