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 [EMAIL PROTECTED] ----- Original Message ----- From: Chris Payne To: [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. [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. [EMAIL PROTECTED] - rating: . Category: Accommodation