Re: SQL select

Hello, This is a reply to an e-mail that you wrote on Mon, 21 Jul 2003 at 11:08, lines prefixed by '>' were originally written by you. > heloo, > i have got a MySQL table: > id_comp id_goods type > has somebody some idea hot to select? This is off topic for this list but here goes... SELECT * FROM tablename GROUP BY id_comp will probably do it. David. -- phpmachine :: The quick and easy to use service providing you with professionally developed PHP scripts :: http://www.phpmachine.com/ Professional Web Development by David Nicholson http://www.djnicholson.com/ QuizSender.com - How well do your friends actually know you? http://www.quizsender.com/ (developed entirely in PHP)