CookieMonster94 Posted November 25, 2013 Share Posted November 25, 2013 (edited) Currently I have a table storing additional information. Each record can have multiple entries. I am able to retrieve all the entries for a specific record and display them on screen although the column name duplicate itself e.g. Additional info: Lorem ipsum dolor sit amet, consectetur Additional info: Lorem ipsum dolor sit amet Additional info: Lorem ipsum Could anyone offer me a suggestion as to how I could overcome this? Any help would be much appreciated. Edited November 25, 2013 by CookieMonster94 Quote Link to comment Share on other sites More sharing options...
Solution iwpg Posted November 25, 2013 Solution Share Posted November 25, 2013 If you are using SQL, how about "Group By"? select name from table GROUP BY name http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html Quote Link to comment Share on other sites More sharing options...
requinix Posted November 25, 2013 Share Posted November 25, 2013 So don't duplicate the label: print it once and then print out all the additional information you found. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.