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

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 DISTINCT(

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

[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 S