Hello world!

echo basename($_SERVER[‘REQUEST_URI’], ‘?’ . $_SERVER[‘QUERY_STRING’]); // returns only file name (test.php)

echo $_SERVER[‘SCRIPT_FILENAME’];  // full path with  / slahes (C:/xampp/htdocs/4126/temp.php)

echo __FILE__;  // full path with  \ slahes (C:\xampp\htdocs\4126\temp.php)

show all duplicate record if a duplicate record field is there

SELECT    tbl_country.* FROM  tbl_country


INNER JOIN (SELECT country_name FROM  tbl_country
GROUP BY country_name HAVING count(country_name) > 1) dup ON  tbl_country.country_name= dup.country_name

Advertisements

Image

4 Comments (+add yours?)

  1. Mr WordPress
    Apr 25, 2009 @ 21:32:33

    Hi, this is a comment.
    To delete a comment, just log in, and view the posts’ comments, there you will have the option to edit or delete them.

    Reply

  2. js
    Apr 25, 2009 @ 21:34:13

    hi

    Reply

  3. jatindersingh
    May 21, 2011 @ 12:00:33

    hello jatinder

    Reply

  4. jatindersingh
    May 21, 2011 @ 12:00:37

    hello jatinder

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: