Skip to main content

Posts

Showing posts from February, 2012

How to find duplicate records in a table. - MySQL or SQL Query to find duplicates in a table

How to find duplicate records in a table? MySQL or SQL Query to find duplicates in a table suppose you have a table like this which represent some user transactions: Table Name : tbl_user_trans transId userId transDate transAmount 1000 USR034 2012-01-01 300.25 1001 USR004 2012-01-08 100.05 1002 USR030 2012-01-11 30.59 1003 USR034 2012-01-08 1000.65 1004 USR050 2012-02-01 19.25 1005 USR034 2012-02-03 403.25 If want to find all Users from the transaction table who had made transactions more than once , then you have to do like this: SELECT userId, COUNT(userId) AS HowMany FROM tbl_user_trans GROUP BY userId HAVING ( COUNT(userId) > 1 ) The query will return userId      HowMany USR034   ...

HOW TO CREATE WEBSITES DRIVEN BY SEO FRIENDLY URLS WITH OUT USING HTACCESS

CREATING WEBSITES DRIVEN BY SEO FRIENDLY URLS WITH OUT USING HTACCESS In this article I will explain how we can create websites which are driven by seo friendly urls with out using htaccess. To read about SEO and HTaccess please read how to create SEO friendly url driven websites using HTaccess rewrite function When we use HTACCESS for SEO friendly redirections, we use mod_rewrite module of apache. We can create seo friendly url driven site with out using the htaccess mod_rewrite module functions. I will try to explain it very simple: take this url path as example " http://www.myphpwebsite.com/ " for this you need a index file in the root folder like this : http://www.myphpwebsite.com/index.php The content for this page will be populated based on a parameter "content" like this : http://www.myphpwebsite.com/index.php?content=home so content of this page changes as the parameter value changes, the contents may be driven from database or include fil...


Urgent Openings for PHP trainees, Andriod / IOS developers and PHP developers in Kochi Trivandrum Calicut and Bangalore. Please Send Your updated resumes to recruit.vo@gmail.com   Read more »
Member
Search This Blog