* Thus wrote Sagar C Nannapaneni: > Hi everybody, > > I'm having a database named "items", inthat > one field name is "itemname" and the contents of > that field is as follows.... > > Monitor 15" - LG > Monitor 17" - Samsung > Keyboard - TVS > Monitor 15" - Samsung > Mouse - Genius > Keyboard - Microsoft > .... > .... > The first part is the component name and the second is the Company name > I need to have the distinct components in this field...like this > > Monitor > Keyboard > Mouse > > Any help would b greatly appreciated....
In order to do that properly, you would need a normalized database, a properly flattened data structure or hacked with some string manipulation. Seek more help from a SQL or mysql list. Curt -- The above comments may offend you. flame at will. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
