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
Member Avatar
+0 forum 21

I have a 2 yrs old website, with plenty of information. The problem is, that this website is collecting information to one place, so it has almost every information, data from other websites. How deep can it affect my SEO? Is there any solution for this if it does? Thank you!

Member Avatar
Member Avatar
+0 forum 17

Hello every one. i am trying to catch duplicate values from a data. in the picture when i want to add new record, then if the record already exists then go to that record and fill all the boxes, then i will press the update button,but if not, then add new value. field is indexed. ![Capture.JPG](/attachments/large/4/782a9b61c49710e943d77ec4b8477343.JPG "align-center") ![Capture.JPG] so how to code that? i need it very much.

Member Avatar
Member Avatar
+0 forum 2

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 />",$unique); ?> <form method="post"> Result <textarea rows="5" cols="30"><?php echo $output;?></textarea><hr/> <textarea name="numbers" class="span8 note" id="numbers" rows="5" cols="30"></textarea><hr/> <input type="submit" value="ADD"/> </form>

Member Avatar
Member Avatar
+0 forum 8

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 keep the ones with the oldest date? I hope this does not come out as a dumb question. I have tried reviewing other posts to see if I could find my answer there but had no luck. Any help would be greatly appreciated! Example: Student ModifiedDate John 06222015 John 06212015 …

Member Avatar
Member Avatar
+0 forum 3

hello, im wondering how to throw an error message to a user if the input value is a duplicate in `INSERT INTO...` I have: <?php require "connection.php"; $name = $_POST["names"]; $event_id = $_POST["events1"]; $euser_id = $_POST["sessions"]; $single_chair_id = $_POST["schair"]; $assign = $dbh->prepare("INSERT INTO cinema(cuser_id,event_id,guest_name,chair_id) VALUES(?,?,?,?)"); $assign->bindParam(1, $euser_id, PDO::PARAM_INT); $assign->bindParam(2, $event_id, PDO::PARAM_INT); $assign->bindParam(3, $name, PDO::PARAM_STR); $assign->bindParam(4, $single_chair_id, PDO::PARAM_STR); $assign->execute(); ?> example 1: name : Xavi event_id: 2 euser_id: 4 single_chair_id: A1 values of example 1 gets inserted yay! example 2: name : Nadia event_id: 2 euser_id: 4 single_chair_id: A1 single_chair_id of example 1 and example 2 are the same, so how …

Member Avatar
Member Avatar
+0 forum 1

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 to receive duplicate packets. (I installed wireshark to investigate the problem in the specific shop). I am not sure if this is causing my application to crash but i have nothing else to blame! :) So the question : **Is there any chance that faulty hardware (router, switches, NICs) or …

Member Avatar
Member Avatar
+0 forum 11

Am developing a two screen application where first screen resides in the user system and other screen in extended mode is directed towards a projector or another monitor. They all are working perfectly. Now my client asked me if I can preview the secondary screen onto the primary screen. I tried to display the form inside a group box using: Dim f1 As New Form2 f1.TopLevel = False f1.Visible = True groupBox1.Controls.Add(f1) and successfully displayed the form. But the problem is that whenever I make changes in the Form2 from main form, I couldn't update the form f1. I tried …

Member Avatar
Member Avatar
+0 forum 3

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 in once. I have create the excel table with the following fields. **Department EmployeeID Name SystemDate SystemTime Status** Based on the employeeID, i want to check whether is there a duplication record in the excel file before appending a new data. My current vb.net code is like that. Private Sub …

Member Avatar
Member Avatar
+0 forum 2

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 values in more than one record. **Table (excerpt):** | id | userid | courseid | | 1 | 23 | 3 | | 2 | 23 | 3 | | 3 | 28 | 5 | | 4 | 28 | 5 | | 5 | 23 | 5 | …

Member Avatar
Member Avatar
+0 forum 4

I have this code which finds the duplicate rows .I want to check if the top row has weight greater than given minimum support..If true then generate its subsets. If row 1 i.e 11110011 wight>min_sup then generate subsets....if not then jump to next row here 1 represents presence of items and 0 represents absence... so row one has 1,2,3,4,9,12 so subsets i need is {1,2,3},{1,3,4},{1,4,9},{1,9,12} {1,2},{1,3}....etc Can anyone help */ package javaapplication42; import java.io.BufferedReader; import java.io.FileReader; import java.io.IOException; public class Smalldataset { public static void main(String[] args) { BufferedReader br = null; String[] line=new String[55]; int n, c, d, swap,i=0,j=0,min_suport,row=0,col=0,no_of_selected_item=0; …

Member Avatar
Member Avatar
+0 forum 2

I have a difficult problem. I know there are so many 're' masters in python out there. So please help me. I have a huge log file. The format is something like this: [text hello world yadda lines lines lines exceptions] [something i'm not interested in] [text hello world yadda lines lines lines exceptions] And so on... So Block 1 and 3 are same. And there are multiple cases like this. My ques is how can I read this file and write in an output file only the unique blocks? If there's a duplicate, it should be written only once. …

Member Avatar
Member Avatar
+0 forum 1

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 I'd managed to double post without actually realising. When I got back to the parent screen (C#) I noticed that the thread said it had 0 replies. Thinking it was a caching issue, I refreshed. Still 0. Went into the thread and my post was still there. Refreshed again. Post …

Member Avatar
Member Avatar
+0 forum 7

Hi, I am using VB6 and phpMyAdmin connected by WAMPServer for my system. I am new in this language. Here's the code in my that seems to be wrong: Private Sub cmdsubmit_Click() Dim rs As ADODB.Recordset Dim strsql As String strsql = "insert into table1 ( surname, firstname, middlename, house, street, village, brgy, city, gender, kind, birthday) values (" _ & "'" & txtsurname.Text & "'," _ & "'" & txtfirstname.Text & "'," _ & "'" & txtmiddlename.Text & "'," _ & "'" & txthouse.Text & "'," _ & "'" & txtstreet.Text & "'," _ & "'" & txtvillage.Text & …

Member Avatar
Member Avatar
+0 forum 6

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 want to compare 3 subitem in listview like this: Date____________Name_______________Value 11/12/13________llallala_______________12334 11/12/13________llallala_______________12334 11/12/13________ddsfvxcv_____________16542 13/12/12________ddsfvxcv_____________12334 10/12/13________owowewe_____________23024 then normally it will remove first and second row because it is duplicate but now it cannot.... I means it just compare between first column....so if the first column is same but second and third …

Member Avatar
Member Avatar
+0 forum 3

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); $sql="SELECT * FROM db, 1st_reminder WHERE stage_two = '1' AND 2nd_email_sent = '0'"; $result = mysql_query($sql) or die(mysql_error()); $count = 1; while ($rows = mysql_fetch_array ($result)) { $to = $rows['contact_email']; $from = "email@domain.com"; $subject = "Subject"; $message .= $rows['1st_body']; $headers = "From:" . $from; mail($to,$subject,$message,$headers); if ($count % 5 == …

Member Avatar
Member Avatar
+0 forum 4

A simple way to find duplicate words in a text. In this case the text is preprocessed to eliminate punctuation marks and set all words to lower case.

Member Avatar
Member Avatar
+2 forum 1

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 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; For **SAME nidt & SAME noeud**, i would like to DELETE rows based on two condition: > 1. If ETAT_FONCT = "OPERATIONAL" Delete REST ROWS EXCEPT HIGHEST Version > > 2. If ETAT_FONCT != "OPERATIONAL" DELETE Older verions *Thanks in advanced for input. :) :)*

Member Avatar
Member Avatar
+0 forum 12

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 .htaccess ? # BEGIN WordPress <IfModule mod_rewrite.c> RewriteEngine On RewriteBase /blog/ RewriteRule ^index\.php$ - [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /blog/index.php [L] </IfModule> # END WordPress My function from the plugin, this is the logs table and after that i'm calling `get_curl_data()` function. function verifica_disponibilitate_curl($post) { $sdstr …

Member Avatar
Member Avatar
+0 forum 1

I’m pretty much new to codeigniter and PHP. I need help with insertion of data in the db from multiple clone form fields(not using implode, I have used implode and managed to push data which I will post here), this from clone form fields(If I click add, it should display another clone of the same form field again is done). Pushing a single value is fine, but when I try pushing in multiple clone form fields at the same time, there is a problem. Or give me a hint as to how. I have attached an image of the dummy …

Member Avatar
Member Avatar
+0 forum 3

This is working code $sql = "REPLACE INTO 2_1_journal (Number,RecordDay, RecordMonth) VALUES "; $insertQuery = array(); $insertData = array(); foreach ($_POST['row_id'] as $i => $row_id) { $insertQuery[] = '(?, ?, ?)'; $insertData[] = $row_id; $insertData[] = $_POST['date_day'][$i]; $insertData[] = $_POST['date_month'][$i]; } if (!empty($insertQuery)) { $sql .= implode(', ', $insertQuery); $stmt = $db->prepare($sql); $stmt->execute($insertData); } Hovewer want to change it to ON DUPLICATE KEY UPDATE. Like $sql = "INSERT INTO 2_1_journal (Number,RecordDay, RecordMonth) VALUES ON DUPLICATE KEY UPDATE (RecordDay, RecordMonth) "; $insertQuery = array(); $insertData = array(); foreach ($_POST['row_id'] as $i => $row_id) { $insertQuery[] = '(?, ?, ?, ?, ?)'; …

Member Avatar
Member Avatar
+0 forum 12

Hey my doubly linked list remove duplictes function will only work when the players in the list are together as in position 1 and 2 or 3 and 4. Otherwise if there not together it will delete the two players. For example, if i have luis suarez at position 1 and have him again at position 3, both luis suarez objects will be deleted when only one is supposed to be removed hence remove duplicate. Here is my code: void RemoveDuplicates(DoublyLinkedListIterator<Datatype> m_itr, string searchByFirstName, string searchBySecondName) { query.clock1(); for(m_itr.Start(); m_itr.Valid(); m_itr.Forth()) { if ((m_itr.Item().getFirstName() == searchByFirstName )&& (m_itr.Item().getSecondName() == searchBySecondName)) …

Member Avatar
Member Avatar
+0 forum 5

this is the below code in which when user press enter then the details of textbox go into gridview then again when user press enter then if that record is already available then not allow to insert in gridview.i a unable to do this please help any one... If Asc(e.KeyChar) = 13 Then If txt_itemno.Text = "" And txt_qty.Text = "" And txt_disc.Text = "" Then ElseIf txt_qty.Text > qty Then MsgBox("Insufficient qty.") txt_qty.Focus() Else Dim intcount As Integer = 0 For Each Row As DataGridViewRow In dgv_sale.Rows If dgv_sale.Rows(intcount).Cells(0).Value = Val(txt_itemno.Text) Then res = MsgBox("Item Already Exist.Do You Want …

Member Avatar
Member Avatar
+0 forum 4

Hi, I would like to know how to find duplicate records based on exact match on some columns and slight difference on others... for example, I have a table with the following fields 1. Name nvarchar(50) 2. City nvarchar(50) 3. State nvarchar(50) 4. Age int(10) Now, I wish to search for records that have similar values in the first three columns and differ in the last column (age) by a value less than or equal to 5. For example **Name City State Age** **ABC MUMBAI MAHARASHTRA 51** PQR KOLKATA WEST BENGAL 51 **ABC MUMBAI MAHARASHTRA 51** PQR BANGALORE KARNATAKA 51 …

Member Avatar
Member Avatar
+0 forum 3

Dear Members/Guests, First of all, I'd like to tell you, the following website I am going to talk about is not created by me, so that's why I am having some problems editing or developing it. The problem is, that I have duplicate content on my website's subpage, have a look at here: http://www.facetivals.com/Dialogues <--- here as you can see, once we have the same information in the table when you click on an event name or venue name, and the same information after it, but not in a table form. Since I have this information in my html file …

Member Avatar
Member Avatar
+0 forum 1

Hello, please am having issues querying my reports from the database. i want to creat a reports from a number tables ( rooms ==> this table is where i have all the room numbers. bookings ==> this table is where i have all the room numbers used per each date. guests ==> this table is where i have all the guest. reservation ==> this table is where i have records on the reservaed rooms and dates. booking this table is where i have records on the checked-in rooms and dates. ) using joining, i created a view with this query …

Member Avatar
Member Avatar
+0 forum 1

Can someone help me to make program which find duplicate files in C++? Thanks a lot!

Member Avatar
Member Avatar
+1 forum 1

Hi there, I am trying to repeat my triangle on 100px by 100px; Any help is much appreciated. Many thanks, Ashley def drawTrianglePatch(win, x, y, colour): for i in range(5): for j in range(5): if (i + j) % 2 == 0: triangle = i * 20 triangle = y + j * 20 triangle = Polygon((Point(100,20), Point(80,60), Point(120,20)), Point( + 20, repeatY + 20)) triangle.setFill(colour) triangle.draw(win)

Member Avatar
Member Avatar
+0 forum 2

anyone know how genetic programming works on finding duplicate records in database?

Member Avatar
Member Avatar
+0 forum 4

Hi, I am trying to eliminate crystal reports duplicates. For some reason, the same record showed 18 times!!!! Craziness!! I tryed to create groups, to check suppress if duplicates .. but nothing happened!! Plz help!

Member Avatar
Member Avatar
+0 forum 1

The End.