fazzfarrell Posted May 16, 2008 Share Posted May 16, 2008 Idone this many times before but now I'm drawing a blank! A table (gallery of pics) with 15 of them refereced '1' and another 10 referenced '2' At the moment I am pulling in all the records all I want to do is pull in one from ref 1 and one from ref 2 and so on how do I do it? Link to comment https://forums.phpfreaks.com/topic/105925-one-record-from-multiple/ Share on other sites More sharing options...
fazzfarrell Posted May 16, 2008 Author Share Posted May 16, 2008 DISTINCT was what I was looking for but does not do the trick! 1 col has number references and the other file name so still shows all the records! Link to comment https://forums.phpfreaks.com/topic/105925-one-record-from-multiple/#findComment-542837 Share on other sites More sharing options...
Barand Posted May 16, 2008 Share Posted May 16, 2008 try ... GROUP BY ref Link to comment https://forums.phpfreaks.com/topic/105925-one-record-from-multiple/#findComment-543003 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.