Re: Display only one filed of the repeated records
| From: | Richard Davey | Date: | Tue, 30 Nov 2004 11:59:00 +0000 |
| Subject: | Re: Display only one filed of the repeated records | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-203126@lists.php.net to get a copy of this message | ||
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(category) FROM blah WHERE blah ...
Best regards,
Richard Davey
--
http://www.launchcode.co.uk - PHP Development Services
"I am not young enough to know everything." - Oscar Wilde