[PHP] Display only one filed of the repeated records

2004-11-30 Thread Ahmed Abdel-Aliem
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 1Matrix

Re: [PHP] Display only one filed of the repeated records

2004-11-30 Thread Marek Kilimajer
Ahmed Abdel-Aliem wrote: 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

Re: [PHP] Display only one filed of the repeated records

2004-11-30 Thread Richard Davey
Hello Ahmed, Tuesday, November 30, 2004, 11:47:40 AM, you wrote: AAA i want to list the categories only like this AAA Sci-Fi - History - Horror This is a MySQL (or whatever DB you are using) question, but if it is MySQL look at the DISTINCT and GROUP BY select elements, i.e. SELECT

Re: [PHP] Display only one filed of the repeated records

2004-11-30 Thread Ed Curtis
On Tue, 30 Nov 2004, Ahmed Abdel-Aliem wrote: 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