29 Solved Topics

Remove Filter
Member Avatar for
Member Avatar for rpv_sen

Hi i am having 3rd party csv file. i am having php uploading script to upload the datas into my table. while uploading datas into my mysql Table mean while it has to remove duplicate entries rows from CSV file. Please help me

Member Avatar for bhuvi_2
0
9K
Member Avatar for blueguy777

How to remove duplicate mobile numbers from input text box1 and print the result into text box2. Example mobile nos: 7795012345 7795012345 7795012345 7411312354 7411312354 9900454321 9900454321 9632554123 9632554123 output should be: 7795012345 7411312354 9900454321 9632554123 <?php $myarray = array(); $myarray['numbers']=$_POST['numbers']; foreach($myarray as $num){ $numbers=$num; } $unique = array_unique($numbers); $output=implode("<br …

Member Avatar for blueguy777
0
534
Member Avatar for amishraa

Hello, What seems so trivial, has been bugging me. I have a table with duplicate values on one column, while non-duplicate (date) values on the other. If I am to use DISTINCT it will only eliminate the row with the same date. But how do I use DISTINCT and only …

Member Avatar for diafol
0
242
Member Avatar for ktsangop

Hello everyone! I have a server/client application running in 4 internet cafes, and i have a packet duplication problem in one of them. I have thoroughly examined my code and tested it in my lab and cannot find any bugs whatsoever. So on rare conditions some of the clients seems …

Member Avatar for Khaled_6
0
2K
Member Avatar for Jing_1

Good Evening Everyone, i am currently facing a problem. I want to append data to an excel file but before that i want to check for duplication records in the excel file before appending. For example, an employee want to check in to a company but he can only check …

Member Avatar for Jing_1
0
237
Member Avatar for mmcdonald

Hi all, I'm looking into the management of duplicate records in MySQL, but this case is a little bit more specific. A record is only duplicated if column A and column B have the same value. So a record is only a duplicate if two specific columns have the same …

Member Avatar for mmcdonald
0
5K
Member Avatar for Ketsuekiame

Hello, I got a message this morning from a mod that had deleted a duplicate post. Which is all fair enough....Except I never saw the duplicate post in question. When I went to check the thread this morning, sure enough my original post was still there so sat bemused that …

Member Avatar for Ketsuekiame
0
300
Member Avatar for oks1998

Dim hTable As Hashtable = New Hashtable() Dim duplicateList As ArrayList = New ArrayList() Dim itm As ListViewItem For Each itm In ListView1.Items If hTable.ContainsKey(itm.Text) AndAlso hTable.ContainsKey(itm.SubItems(1).Text) AndAlso hTable.ContainsKey(itm.SubItems(2).Text) AndAlso hTable.ContainsKey(itm.SubItems(3).Text) Then 'duplicate duplicateList.Add(itm) Else hTable.Add(itm.Text, String.Empty) End If Next 'remove duplicates For Each itm In duplicateList ListView1.Items.Remove(itm) Next I …

Member Avatar for tinstaafl
0
1K
Member Avatar for urbanthistleuk

Hello, First of all apologies if this has been posted before, having trouble findin the answer, Let me start by inserting the code I have having the problem with, apologies if this isn't the correct way of doing things but I am still a newbie at php <?php include('config.inc'); mysql_select_db($dbname); …

Member Avatar for urbanthistleuk
0
262
Member Avatar for PriteshP23

PFA...!! **Please look at the table data carefully.** I need to delete the rows. I need urgent help..!! Table: CREATE TABLE IF NOT EXISTS `version` ( `nidt` varchar(11) NOT NULL, `noeud` tinyint(3) NOT NULL, `VERSION` float NOT NULL, `ETAT_FONCT` varchar(20) default NULL, `idnap` varchar(25) NOT NULL, `nidtint` bigint(20) NOT NULL …

Member Avatar for PriteshP23
0
319
Member Avatar for Szabi Zsoldos

Hi guys, I've created a simple plugin for Wordpress that interacts with an API in the backend. The problem is that everything is inserted twice in the database, and I cannot figure out why. The form is submiting only once, not twice. What could it be ? Redirects from my …

Member Avatar for Szabi Zsoldos
0
847
Member Avatar for pucivogel

I want to check for duplicates when inserting a new contact in my database, then showing a msg that the contact is already in the db. this is what i've done: function isDuplicate(names,phone,email,adresa){ var isduplicate=false; for(var i=0;i<addresslist.length; i++){ if(addresslist[i].names.toLowerCase()==names.toLowerCase() && addresslist[i].phone.toLowerCase()==phone.toLowerCase()&& addresslist[i].email.toLowerCase()==email.toLowerCase()&& addresslist[i].adresa.toLowerCase()==adresa.toLowerCase() ){ isduplicate=true; } } return isduplicate; } …

Member Avatar for stbuchok
0
185
Member Avatar for richprich

Although there are many similar questions and answers here and i've tried my best to make it work but no luck. This is my code: $content = "Blah...blah...[image=1], blah...blah...blah...[image=2], blah...blah...blah...[image=1], no more..."; function get_image($content) { $stripper = $content; preg_match_all("/\[image=(.+?)\]/smi",$stripper, $search); $total = count($search[0]); for($i=0; $i < $total; $i++) { $image_id …

Member Avatar for richprich
0
601
Member Avatar for mgunia

Hello Everyone! I am a beginner user of Python without IT background (I am interested in IT developing my knowledge step by step). So far I did simple scripts in Python and I encountered a problem. I was looking on Google, however I didn't find the satisfactory answers which would …

Member Avatar for vegaseat
0
9K
Member Avatar for inneedofhelp123
Member Avatar for Knowledge72
1
227
Member Avatar for stephen_UK

For reason I won't bore you with, I need to update an archive database periodically with typically blocks of 100-300 records. Each record has 6 visible fields in the database. Frequently 4 of the 6 fields have the same information in them for the whole block of data. For a …

Member Avatar for stephen_UK
0
248
Member Avatar for cigoL..:)

Hi guys! I'm currently making an integration of 2 different web apps. I would to ask if is it possible to restrict adding duplicate data in your table. for Example i have two different tables from two different databases. App1_Invoice (from Web App 1 database) e.g. transno name amount App2_Invoice …

Member Avatar for cigoL..:)
0
294
Member Avatar for Secone

Here's the entirety of my code. The problem I'm having trouble with is in the sortArray function. The first part of that function is used to sort the words gathered in a text file from A to Z, the second part is meant to find any duplicate words, ie 'a' …

Member Avatar for Secone
0
205
Member Avatar for Secone

I'm trying to have my program find duplicates in an array of strings, and if it finds one, it swaps the duplicate to itemamount - 1, adds +1 to the WordAmt for that word, and moves the loop one spot down. I just am not sure how to properly do …

Member Avatar for VernonDozier
0
232
Member Avatar for stupid guy

Hello all, i get this error while inserting and udating some tables.Duplicate entry '9105224' for key 'PRIMARY'error no:1062error:1062 .number 9105224 is randomly generated and set in u_id field in one of the tables in MYSQL, which is set to unique and primary.The sql querries are working fine and the rows …

Member Avatar for stupid guy
0
686
Member Avatar for sam1

Hi, Want to remove duplicates from a list so if my list contains: [CODE]www.test.com test.com mytest.com[/CODE] I want the final list to look like below(only selecting the domains with www from the duplicate in front) : [CODE]www.test.com mytest.com [/CODE] I have this linq but it seems to ignore all the …

Member Avatar for sam1
0
234
Member Avatar for neosonic

Hi all, I need your help. I have an insert query which insert a few rows into the table A. TableA has two primary keys, which are fieldA and fieldB. The SQL is written as follows: INSERT INTO TableA (fieldA , fieldB, fieldC, fieldD) SELECT DISTINCTROW TableB.fieldA, TableB.fieldB, TableB.fieldC, TableB.fieldD …

Member Avatar for neosonic
0
187
Member Avatar for ChrisHunter

Hi, i'm having a problem trying to print out a list of strings. i can get them to print out using rectangles successfully but when the bottom of the page is reached it wont go onto the next page, instead it just stops printing. I've done this so far which …

Member Avatar for ChrisHunter
0
936
Member Avatar for tstory28

I have been working on a pythagorean theorem calculator and am actually stuck on the final bit of code. What I am trying to do is check the values (integers) inside a listbox, remove duplicate number (both values), and input one of the values into a textbox. Here is an …

Member Avatar for tstory28
0
1K
Member Avatar for r0n

hello everyone, got issue regarding reading duplicate records in a text file... i need to read the file and look for any duplicates data/keys in the text file and write them to another file (all the duplicates records)... how can i do that, in looping...:-/ any help...:) thanks!

Member Avatar for r0n
0
2K
Member Avatar for acejhon

hi to everyone, im having trouble with python programming... i have these 3 problems.... 1. remove a duplicates in a sorted integer 2. a python program that will detect if a number is divisible by 3 if you have solutions for my problems, can you help me pls...

Member Avatar for TrustyTony
-2
283
Member Avatar for kiryoku

I need to delete duplicating input.. for example. in a list box I input a a a b b then I want to delete all 'a' the listbox must show: b b i hope there is someone who can help me..thanks!! Public Class Form1 Private Sub btnadd_Click(ByVal sender As System.Object, …

Member Avatar for kiryoku
0
125
Member Avatar for SerjSagan

I am getting a weird error in Google Webmaster Tools when my site is accessed as [url]http://www.myurl.com/[/url] it shows duplicate meta tags for a [url]http://www.myurl.com/?ref=wierdurl.com[/url] I have no relation to this weird url, but obviously it is linked to my site this way and Google sees it as a separate …

Member Avatar for jay 11
0
163
Member Avatar for jb1ker

Hi. I'm changing a site's URL to a new domain. The site is hosted at freewebs.com which makes it impossible to create redirects (unless anybody proofs different). What is the most efficient way to make sure I don't get penalized by Google for duplicate content? As the new domain is …

Member Avatar for jb1ker
0
133

The End.