 |
 |
 |
 |
|
|
Date: 10/30/01
- Next message: Bas Jobsen: "[PHP-DB] select take (too) much time"
- Previous message: * R&zE:: "Re: [PHP-DB] Variables in a loop"
- In reply to: Chris Payne: "[PHP-DB] Need help with duplicate entries"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Use a "Select Distinct....." query. See www.mysql.com/doc for more info
-- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send blank email to pgpkey <email protected>----- Original Message ----- From: Chris Payne To: php-db <email protected> Sent: Monday, October 15, 2001 9:59 PM Subject: [PHP-DB] Need help with duplicate entries
Hi there everyone,
I'm working on a project for a friend who owns a travel agent, he has a MySQL database which works very fast, but the problem is that there are alot of duplicate entries. When I am retrieving the results from the DB and getting it ready to display on the page, how do I eliminate duplicates via a query? What I mean is (See below) I have backpackeurope.com many times but for different countries, when you search for backpacking it brings all the countries up under one another - how do I make it only bring 1 entry up of each entry rather than all of them?
Confused? That's how I feel :-)
Thank you all so much.
Chris Payne
www.backpackeurope.com Backpackers/Hostels in Austria Backpacking and hostelling tips and links for student and budget travellers planning a trip to europe. kaaryn <email protected> - rating: . Category: Accommodation
www.backpackeurope.com Backpackers/Hostels in England Backpacking and hostelling tips and links for student and budget travellers planning a trip to europe. kaaryn <email protected> - rating: . Category: Accommodation
- Next message: Bas Jobsen: "[PHP-DB] select take (too) much time"
- Previous message: * R&zE:: "Re: [PHP-DB] Variables in a loop"
- In reply to: Chris Payne: "[PHP-DB] Need help with duplicate entries"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]