its for showing a users folders. (for private messages)
how can i select one of each folder name because i know that there will be more than 1 folder name that is the same.
i have a mysql column called folder and there is a folder name in each row.
i want to display to the user his/her available folders BUT NOT REPEAT
how do i do that ?
i already know if i user SELECT folder FROM table then ill get them all how do i make it so i only get one of each name?