heloo, i have got a MySQL table:
id_comp id_goods type cooler aa1256 n cooler aa1255 n cooler aa1317 f cooler aa1196 n cpu cpu183 n cpu cpu177 f cpu cpu190 n gk gk1265 f gk gk1258 n gk NULL i gk gk1193 n gk gk1257 n mb mb1111 f ram mem713 n ram me1112 f ram mem704 n ram me1081 n and I need only first row of each component order by type. so: cooler aa1317 f cpu cpu177 f gk NULL i mb mb1111 f ram me1112 f has somebody some idea hot to select? jiří němec, ICQ: 114651500 www.menea.cz - www stránky a aplikace -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php