Jamz Posted March 20, 2008 Share Posted March 20, 2008 Hi again, Right, im trying to get this phone website sorted, it uses a database which has loads of different phones and different phone networks. Each phone network has the same kinda phone, so when im outputting info from the database, im selecting things like just the nokia phones, but it outputs around 10 of the same phone: http://www.jamessimpson.org/PhoneWeb/showbrand.php?brand=Nokia How can i make it so it only shows the one phone, and then goes into the next? Ive tried a few things, but didnt work Cheeers Jame Link to comment https://forums.phpfreaks.com/topic/97068-stop-multiple-outputs/ Share on other sites More sharing options...
beebum Posted March 20, 2008 Share Posted March 20, 2008 SELECT UNIQUE... Link to comment https://forums.phpfreaks.com/topic/97068-stop-multiple-outputs/#findComment-496694 Share on other sites More sharing options...
Jamz Posted March 20, 2008 Author Share Posted March 20, 2008 like this: $query = "SELECT UNIQUE FROM Phone_Feed WHERE `Model.Make`='$brand'"; ? Link to comment https://forums.phpfreaks.com/topic/97068-stop-multiple-outputs/#findComment-496704 Share on other sites More sharing options...
Jamz Posted March 20, 2008 Author Share Posted March 20, 2008 I got it working using DISTINCT instead. Cheers for that! Link to comment https://forums.phpfreaks.com/topic/97068-stop-multiple-outputs/#findComment-496713 Share on other sites More sharing options...
beebum Posted March 20, 2008 Share Posted March 20, 2008 hehe, yeah DISTINCT is what I meant to say. Link to comment https://forums.phpfreaks.com/topic/97068-stop-multiple-outputs/#findComment-496715 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.