Monthly Archives: December 2010

PHP Execution Time

Again, I am executing a file with a while loop for more than hundred data. Now, PHP did not allow to execution for a more than 30 seconds by default. So, We have another solution for the same. PHP provide … Continue reading

Posted in Development | Tagged , | Leave a comment

Replace space to hyphen in MySql

phpmyadmin_csv_upload_4

Again, I am publishing another mysql query to replace the space with the hyphen. also Below is the replace space to hyphen in MySql Query:- SELECT `id` , name, REPLACE( LCASE( name ) , ‘ ‘, ‘-‘ ) AS alias1 … Continue reading

Posted in Development, MySql | Tagged , | 1 Comment

Finding non-duplicate records from different MySql Tables

SQL Query For DeDuplication of Records

I was searching for the solution to match two database table with same or different fields and remove the data which is present in both tables. After goggling a lot, I realize find and remove duplicate records in mysql is … Continue reading

Posted in Development, MySql | Tagged , , , , | 7 Comments

Regular Expressions

Since a Last night, I was searching for the good regEx generator. and I found a very nice build on flash where I got a new expression for html tags which I like most to retrieve data from the html  … Continue reading

Posted in Development | 1 Comment