29 Solved Topics
Remove Filter | |
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 | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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); … | |
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 … | |
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 … | |
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; } … | |
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 … | |
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 … | |
Can someone help me to make program which find duplicate files in C++? Thanks a lot! | |
| 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 … |
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 … | |
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' … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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! | |
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... | |
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, … | |
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 … | |
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 … |
The End.