Finding Duplicates with SQL:: SELECT `email`, COUNT(`email`) AS NumOccurrences FROM `user` GROUP BY `email` HAVING ( COUNT(`email`) > 1 )
Read MoreHow to split a single column values to multiple column values
How to split a single column values to multiple column values:: For Example: #Current table Field is like:: Name ———— abcd efgh ijk lmn opq …
Read MoreCheck if Image Exists or Not corrupted in Php
Check if Image Exists or Not corrupted in Php $full_path = Full Image path; (Like: ../dd/tmp.jpg) if(!file_exists($full_path)){ //Image Not Available or Not Exists }else{ //Image …
Read MoreUpdate Two Column Field By Splitting The VAlue from One Column in SQL.
Update Two Column Field By Splitting The VAlue from One Column in SQL. Here the split will be done depending on space in name. Here …
Read MoreUpdate two column field by Splitting the value from one column in SQL
Update two column field by Splitting the value from one column in SQL QUERY:QUERY: UPDATE user u2 set u2.first_name = SUBSTRING_INDEX(u2.name, ‘ ‘, 1), u2.last_name …
Read MoreHow To Remove html tags from validation_errors() in Codeigniter
How To Remove html tags from validation_errors() in Codeigniter Remove html tags from validation_errors() in Codeigniter Set the Opening tag and Closing Tags for error …
Read MoreSQL update from one Table to another based on a ID match
SQL update from one Table to another based on a ID match MS SQL UPDATE Sales_Import SET Sales_Import.AccountNumber = RAN.AccountNumber FROM Sales_Import SI INNER JOIN …
Read MoreHow to Align A image Center of Div (top,bottom,left,right) using CSS ??
How to Align A image Center of Div (top,bottom,left,right) using CSS ?? Example: <div class=”image”> <img alt=”” src=”Path” /> </div> CSS:: .image { …
Read MoreAlign a image in the center of the Div using CSS
Align a image in the center of the Div using CSS Stack of Codes HTML: <div class=”frame”> <img src=”foo”/> </div> CSS: .frame { …
Read MoreSQL – How to split a single column values to multiple column values
How to split a single column values to multiple column values.. For Example: #Current table Field is like:: Name ———— abcd efgh ijk lmn opq …
Read More