Skip to main content

Find duplicate records in MySQL


Find duplicate users by name with this query..

SELECT a.name
FROM tbl_users a
INNER JOIN tbl_users b ON a.name = b.name
WHERE a.id <> b.id
LIMIT 0 , 30

Comments

Popular posts from this blog

Jquery form validation with ajax request

Include library <script src = "js/jquery.min.js" ></script> <script src = "js/jquery.validate.js" ></script> <?php $_SESSION [ 'code' ]= rand ( 1000 , 2000 ); ?>   <form name = "form-signup" id = "form-signup" method = "post" > <table width = "50%" > <tr> <td> Name </td> <td><input type = "text" name = "name" id = "name" class = "change" ></td> </tr> <tr> <td> Email </td> <td><input type = "text" name = "email" id = "email" class = "change" ></td> </tr> <tr> <td> Username </td> <td><input type = "text" name = "username" id = "username" class = "chan

Select Insert Update Delete With Image In Php MySQL

        CRUD with image upload is a very common task in web development ( CRUD stands for Create/Read/Update/Delete ). The main purpose of a CRUD is that enables user’s create/read/update/delete data using PHP & MYSQL. Table of Content Create Database Insert Record with image upload Show Record Edit Record Delete Record     

PHP+AJAX+MYSQL: Sort & Save using Drag & Drop (TABLE TR)

" Drag, Drop, Sort, Save "  Drag & Drop : Move the draggable element by clicking on it with the mouse and dragging it anywhere within the viewport. Sor t: The sort order can be either alphabetic or numeric, and either ascending or descending.       Here we had created demo that allow the user to drag and drop elements and quickly  and save them with PHP + MySQL+ AJAX +JQUERY on the server side. Table of content 1) Drag and drop element on every click 2) Sort data on the server side using PHP+MYSQL 3) Great user interface and  easy to execute with a few lines of code