hi, JiøîÆèî eË wrote: > hello, > > i have got a problem with SQL select: > > I have got a table such this: > > id_k typ name id > 1 f bla1 1 > 2 f bla2 1 > 2 i bla3 1 > 3 z bla4 1 > 3 f bla5 1 > 4 i bla6 1 > 4 z bla7 1 > 5 z bla8 1 > > and id = 1 and I need select these rows: > > id_k typ nazev id > 1 f bla1 1 > 2 f bla2 1 > 3 f bla5 1 > 4 i bla6 1 > > so, when doesn'i exist component (id_k = component) type "f" so I want > component with type "i", but when doesn't exist type "f" noir "i" I > don't want to select row with type "z". > > jiri nemec, ICQ: 114651500 > www.menea.cz - www stránky a aplikace
don't know, if i correctly understood, but how about this: SELECT * FROM `YourTable` WHERE `typ`="f" OR `typ`="i" ODER BY `typ`; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
