Hi, To avoid this, try and catch this at the input level by checking the database whether there is a value like the one being posted. This will minimize the duplicate records in the database. Hope this helps. --- In php-objects@xxxxxxxxxxxxxxx, Gustavo Oliveira <g_oliveira@...> wrote: > > use php with SQL command in your database > > SELECT * > FROM yourtable > WHERE name LIKE 'ramada%' > > with result > you can delete , edit or check the duplicate hotel name in your database > > Regards > > > > > > ________________________________ > De: Farhan khalid <farhan2kf@...> > Para: php-objects@xxxxxxxxxxxxxxx > Enviadas: Quinta-feira, 17 de Fevereiro de 2011 6:28:48 > Assunto: mysql duplicate records > > > Hello, > > I have duplicate hotel names in my database like > > 1.media rotana > 2.media rotana, barsha - dubai > 3.media rotana barsha dubai > > another example > 1.ramada inn hotel denver > 2.ramada inn resorts denver > 3.ramada inn tower and resorts denver > > As you can see these 3 hotels are same but we have duplicate records so can > anyone tell me is it possible to make some php code to find duplicate hotels > like these? > > Regards > Farhan > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] >
