Display only one filed of the repeated records
| From: | Ahmed Abdel-Aliem | Date: | Tue, 30 Nov 2004 11:47:40 +0000 |
| Subject: | Display only one filed of the repeated records | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-203121@lists.php.net to get a copy of this message | ||
Hi,
i have a tables in database which fields is
id - title - category
what i want to do is to display the categories entered in the
categories fields, without repeating any of them
for eample if the records is like follow
ID Title Cattegory
1 Matrix Sci-Fi
2 Spartacus History
3 Alexander History
4 whatever Horror
i want to list the categories only like this
Sci-Fi - History - Horror
can anyone help me throught this please ?