Webocreation

Thursday, December 31, 2009

Making contact form using php and mysql

Making a contact form in Php.
    Introduction:

  For this you will need basic php knowledge, patience and a willingness to  learn. You will also need a text editor ( I am  using notepad for example ) and a means of testing out this script, a server on  your pc for example.


  Part 1 - The form.


  Well seeing as we are making a contact form I thought it best to start off with  making the form. This is only simple html and I expect you all know this already. But for a contact form I am going to  include:

  - A name box

  - A contact drop down list

  - A subject box

  - A email box

  - A message box

  - A submit button

  - A reset button


  So on with the code:

  Code:

       <div  align="center">

       <form action="" method="POST">

       <b> Please enter your name:</b><br>

       <input type="text" name="name" size  = 30><br><br> <!-- the name box //-->

       <b> Please choose a contact: </b><br>

       <select name="contact">

       <option value="1"> Person 1

       <option value="2"> Person 2

       <option value="3"> Person 3

       </select><br><br>

       <b> Please enter a subject:</b><br>

       <input type="text" name="subject"  size = 30><br><br><!-- the subject box //-->

       <b> Please enter your email  address:</b><br>

       <input type="text" name="email" size  = 30><br><br><!-- the email box //-->

       <b> Please enter your message: </b><br>

       <textarea name="message" cols = 20 rows =  10>

             </textarea><br><br>

       <input type="submit" value="submit"  name="submit_1"><br>

       <input type="reset"  value="reset">

       </form>

       </div>


  Now that we have our form sorted we can move on to the really interesting  stuff, the php! Now you'll have to read and pay attention  to this to fully understand so pay attention!


  Part 2 - Declaring the variables.

  Now when the user presses submit on the form, the form values ( the nanme,  contact, subject, email and message ) are all  "POSTED" to the php script that is usually found in the form's action  tag like below:

  Code:

  <form  action="scripthere.php" method="POST">


  As you can see in our example we don't have an action, but that's because I'm  going to show you a neat little trick using the isset() function! But more of that later. So we want to declare the form values  into variables that we can use in our php script.

  Code:

  <?php

  $name = $_POST['name'];

  $contact = $_POST['contact'];
  $subject = $_POST['subject'];

  $email = $_POST['email'];

  $message  = $_POST['message'];


  ?>

  Great! Doesn't look like much and it sure doesn't do anything! Now we need to  stop and think, we are taking in input from people off the internet. Things could go wrong! You could get people who forget to fill in  certain parts of the form, or people ( for what ever reason )  who feel the need to submit empty forms and spam your inbox! How can we stop  this? Well I'm going to show you the error control.

    Part 3 - Error control.

  So if the user has submitted a form and any of the fields are left blank that  means that the php variable we delcared before for that field  will be blank! so we need to check IF the variable equals "". We need  to declare a new variable first, and I'll tell you why a little later on!

  Code:

  <?php

  $name = $_POST['name'];

  $contact = $_POST['contact'];

  $subject = $_POST['subject'];

  $email = $_POST['email'];

  $message  = $_POST['message'];

  $error = "";

  ?>


  Now that we have the new variable we can start with our if statements to check  if the variables are blank and if they are we add a message to the  variable "$error".

  Code:

  <?php

  $name = $_POST['name'];

  $contact = $_POST['contact'];

  $subject = $_POST['subject'];

  $email = $_POST['email'];

  $message  = $_POST['message'];

  $error = "";

  if($name=="") $error.="*Please  enter a name"."<br>";
  if($subject=="") $error.="*Please  enter a subject"."<br>";

  if($email=="") $error.="*Please  enter a email"."<br>";

  if($message=="") $error.="*Please  enter a message"."<br>";

  ?>
  So as you can see above if they leave a textbox blank then we add a sentence to  a variable called $error asking the user to fill it in again. The if statements dont have the curl brackets "{ }" because the if statement  is all on one line. If the if statement went onto two lines I would need the  curly  brackets. So we have our error control done! Hold up you may be thinking , we  haven't checked the $contact variable. Well read on and you will find out.

  Part 4 - Sorting out those contacts ( with a security measure ).

  Now if you look at the part of the form where the user selects a contact you  will see the following:

  Code:

  <select name="contact">

       <option value="1"> Person 1

       <option value="2"> Person 2

       <option value="3"> Person 3

       </select>

  This means if the user chooses to contact person 1 then the variable $contact  will have the value "1", if they chose person 2 $contact will have a  value of "2" and if they decided to contact person 3...you guessed it $contact has the value  of "3". Now hold up one minute, this is the person they want to  contact, the  numbers 1, 2 and 3 aren't email address' how can you email them?! Well that was  my security measure. If someone were to look at the source code of the sit  and seen this:

  Code:
  <select name="contact">

  <option value="topsecretemail@test.co.uk"> Contact me

  </select>
 
  They would have your email address and then that would render the contact form  pointless! So we are going to use a lovely little thing called a switch (case).  This  is the code:

  Code
  <?php

  $name = $_POST['name'];

  $contact = $_POST['contact'];

  $subject = $_POST['subject'];

  $email = $_POST['email'];

  $message  = $_POST['message'];

  $error = "";

  if($name=="") $error.="*Please  enter a name"."<br>";

  if($subject=="") $error.="*Please  enter a subject"."<br>";

  if($email=="") $error.="*Please  enter a email"."<br>";

  if($message=="") $error.="*Please  enter a message"."<br>";

  switch ($contact){

       case 1:

          $contact = "person1@testmail.com";

          break;

       case 2:

           $contact  = "person2@testmail.com";

           break;

       case 3:

           $contact  = "person3@testmail.com";

           break;

       default:

            $contact  = "person1@testmail.com";

            break;

  }
  ?>


  Now there's a lot to explain so listen up! Basically the switch (case) is like  a group of if statements. You start off by declaring the switch statement with  suprisingly:

  Code:

  switch

  You then delcare the variable you want to check , in our case $contact.

  Code:

  switch ($contact)

  Then you add your cases, as you can see in our example, we have case 1, 2, 3  and default.

  Code:

  switch ($contact){

       case 1:

          $contact = "person1@testmail.com";

          break;


  What has happened above is as follows. The switch case checks the value of  $contact, if it equals "1" it runs the code in "case 1" so  in our example it changes the value of $contact to person1@testmail.com, then I use a break  statement to break out of the switch statement, otherwise it would  run through all of the cases! Then at the end I added a default case, this is  used incase the value of $contact doesn't equal either 1, 2 or 3.

  Now we have sorted out all our variables , and checked them.

  Part 5 - To send the email or not to send the email , that is the question.

  Now this is a contact form we only want to send the email IF the whole form has  been filled  in correctly. If it hasn't we want to send the user a error message and tell  them to try again. Now look at our code, if the form has been filled in  correctly  then the variable $error will still equal nothing :

  Code:

  $error = "";

  HOWEVER if the user has left a field blank then the $error message will contain  a sentence, for example:

  Code:

  $error = "*Please enter a  name"."<br>";

  So we will only send the email IF $error = "", lets update our code:

  Code:

  <?php

  $name = $_POST['name'];

  $contact = $_POST['contact'];

  $subject = $_POST['subject'];

  $email = $_POST['email'];

  $message  = $_POST['message'];

  $error = "";

  if($name=="") $error.="*Please  enter a name"."<br>";

  if($subject=="") $error.="*Please  enter a subject"."<br>";

  if($email=="") $error.="*Please  enter a email"."<br>";

  if($message=="") $error.="*Please  enter a message"."<br>";


  switch ($contact){
       case 1:

         $contact = "person1@testmail.com";

         break;

       case 2:

           $contact  = "person2@testmail.com";

           break;

       case 3:

           $contact  = "person3@testmail.com";

           break;

       default:

            $contact  = "person1@testmail.com";

            break;

  }

   if($error==""){
      //code here to send the email

  }

  else{

      echo "<div align='center'>". $error  ."</div>";

  }

  ?>

 
  There we go now if the user doesn't fill the form in properly, the email isn't  sent, and they are told where they made a mistake! Beautiful!
  Part 6 - Bringing it together a little bit.

  Remember in part 2 when I told you I was going to teach you about the cool  little function "isset()". Well my friends this is the time! As well  as that we will also be involving our html form into our php! So let's begin.

  The user fills the form in and presses the submit button, the variables are  then all "posted" to the php script. We can make a variable  for the submit button! Now if we have a variable for the submit button we can  tell if the user has pressed the submit button or not! If they have  pressed it then the variable will be there! If they haven't pressed it then it  wont! So let's add the isset() function to our code:

  Code:

  <?php

  if(isset($_POST['submit_1'])) {
  [/color]

  $name = $_POST['name'];

  $contact = $_POST['contact'];

  $subject = $_POST['subject'];

  $email = $_POST['email'];

  $message  = $_POST['message'];

  $error = "";


  if($name=="") $error.="*Please  enter a name"."<br>";

  if($subject=="") $error.="*Please  enter a subject"."<br>";

  if($email=="") $error.="*Please  enter a email"."<br>";

  if($message=="") $error.="*Please  enter a message"."<br>";


  switch ($contact){

       case 1:

          $contact = "person1@testmail.com";

          break;

       case 2:

           $contact  = "person2@testmail.com";

           break;

       case 3:

           $contact  = "person3@testmail.com";

           break;

       default:

            $contact  = "person1@testmail.com";

            break;

  }

      if($error==""){

      //code here to send the email

  }
else{
      echo "<div align='center'>". $error  ."</div>";
  }

  }

    else {

  ?>
    <div align="center">

       <form action="" method="POST">

       <b> Please enter your name:</b><br>

       <input type="text" name="name" size  = 30><br><br> <!-- the name box //-->

       <b> Please choose a contact: </b><br>

       <select name="contact">

       <option value="1"> Person 1

       <option value="2"> Person 2

       <option value="3"> Person 3

       </select><br><br>

       <b> Please enter a subject:</b><br>

       <input type="text" name="subject"  size = 30><br><br><!-- the subject box //-->
       <b> Please enter your email  address:</b><br>

       <input type="text" name="email" size  = 30><br><br><!-- the email box //-->

       <b> Please enter your message: </b><br>

       <textarea name="message" cols = 20 rows =  10>

       </textarea><br><br>
       <input type="submit" value="submit"  name="submit_1"><br>

      <input type="reset"  value="reset">

       </form>

       </div>
  <?php

  }

  ?>
  Now you maybe looking at that and thinking , what the . . . but don't be  scared! It's quite simple. We check to see if the user has  pressed submit:

  Code:

  if(isset($_POST['submit_1'])) {

  if they have we move onto our php script, if they haven't we display the form!  Genius!

  Part 7 - The code to send the email!

  Now the code above may look a little tricky but don't worry, if you've read the  tutorial, then you should understand it as  I've broken it down piece by piece. Now we get onto the stuff that the contact  form was made for, sending the email! And for this we are going to use the mail() function.

  Firstly I'm going to describe the mail() function a little bit. We use our  pre-defined already checked variables as parameters is  the mail() function.

  Here is how it is:

  Code:

  mail($contact, $subject, $message, $headers);

  Now we need to add a new variable, $headers, this will include basic  information about who the email is from. Let's update our code:
  Code:

  <?php

  if(isset($_POST['submit_1'])) {

  $name = $_POST['name'];
  $contact = $_POST['contact'];

  $subject = $_POST['subject'];

  $email = $_POST['email'];

  $message  = $_POST['message'];

  $error = "";

  $headers = 'From:'.' '. $email;

  if($name=="") $error.="*Please  enter a name"."<br>";

  if($subject=="") $error.="*Please  enter a subject"."<br>";

  if($email=="") $error.="*Please  enter a email"."<br>";

  if($message=="") $error.="*Please  enter a message"."<br>";


  switch ($contact){

       case 1:

          $contact = "person1@testmail.com";

          break;

       case 2:

           $contact  = "person2@testmail.com";

           break;

       case 3:

           $contact  = "person3@testmail.com";

           break;

       default:

            $contact  = "person1@testmail.com";

            break;

  }

    if($error==""){

      mail($contact, $subject, $message, $headers);

  }

  else{

      echo "<div align='center'>". $error  ."</div>";

  }

  }

    else {

  ?>

    <div align="center">
       <form action="" method="POST">

       <b> Please enter your name:</b><br>

       <input type="text" name="name" size  = 30><br><br> <!-- the name box //-->

       <b> Please choose a contact: </b><br>

       <select name="contact">

       <option value="1"> Person 1

       <option value="2"> Person 2

       <option value="3"> Person 3

       </select><br><br>

       <b> Please enter a subject:</b><br>

       <input type="text" name="subject"  size = 30><br><br><!-- the subject box //-->

       <b> Please enter your email  address:</b><br>

       <input type="text" name="email" size  = 30><br><br><!-- the email box //-->

       <b> Please enter your message: </b><br>

       <textarea name="message" cols = 20 rows =  10>


       </textarea><br><br>

       <input type="submit" value="submit"  name="submit_1"><br>

       <input type="reset"  value="reset">

       </form>

       </div>

  <?php

  }

  ?>

  There we go! Our script now takes input from the user via a form, checks the  data, if the data is good then it sends the email. But how will  we know if the email was sent sucessfully or failed to send?

 

  Part 8 - Success?

  We can do this with a simple if statement around the mail function:

  Code:

  if(mail($contact, $subject, $message, $headers)){
     echo " Email was sent ";

  }

    else {

  echo " Email failed to send ";

  }

  There we go, let's add this to our script:

  Code:

  <?php

  if(isset($_POST['submit_1'])) {

  $name = $_POST['name'];
  $contact = $_POST['contact'];

  $subject = $_POST['subject'];

  $email = $_POST['email'];

 $message  = $_POST['message'];

 $error = "";

  $headers = 'From:'.' '. $email;

  if($name=="") $error.="*Please  enter a name"."<br>";

  if($subject=="") $error.="*Please  enter a subject"."<br>";

  if($email=="") $error.="*Please  enter a email"."<br>";

  if($message=="") $error.="*Please  enter a message"."<br>";



  switch ($contact){
       case 1:
          $contact = "person1@testmail.com";
          break;
       case 2:
           $contact  = "person2@testmail.com";
           break;
       case 3:

           $contact  = "person3@testmail.com";

           break;

       default:

            $contact  = "person1@testmail.com";

            break;

  }

    if($error==""){

            if(mail($contact, $subject, $message, $headers)){

     echo " Email was sent ";

  }

    else {

  echo " Email failed to send ";

  }
  }
  else{

     echo "<div align='center'>". $error  ."</div>";

  }

  }

    else {

  ?>

    <div align="center">

       <form action="" method="POST">

      <b> Please enter your name:</b><br>

      <input type="text" name="name" size  = 30><br><br> <!-- the name box //-->

      <b> Please choose a contact: </b><br>

      <select name="contact">

      <option value="1"> Person 1

       <option value="2"> Person 2

       <option value="3"> Person 3

       </select><br><br>

       <b> Please enter a subject:</b><br>

       <input type="text" name="subject"  size = 30><br><br><!-- the subject box //-->

       <b> Please enter your email  address:</b><br>

       <input type="text" name="email" size  = 30><br><br><!-- the email box //-->

       <b> Please enter your message: </b><br>

       <textarea name="message" cols = 20 rows =  10>


       </textarea><br><br>

       <input type="submit" value="submit"  name="submit_1"><br>

       <input type="reset"  value="reset">
       </form>

       </div>
  <?php

  }

 ?>

Tuesday, December 29, 2009

video download v pop music singles watch music videos listen to free streaming mp3s read pussy cat's blog

the pussycat dolls buttons, pussy cat dolls popular songs latest news of pussy cat,photos of pussy cat video of pussy cat tour dates and more of pussy cat bad romance exclusive video premiere a total of 555 full length pussy cat poker video pussy cat just dance video pussy cat myspace video pussy cat paparazzi video pussy cat, lovegame video pussy cat fame video pussy cat's sexy cinematic “paparazzi” video download v pop music singles watch music videos listen to free streaming mp3s read pussy cat's blog high quality ladygaga music videos for you to watch to embed into your page/profile or to discuss with video

pussy cat songs


pussy cat songs

The Pussycat Dolls - Show Me What You Got (Manchester)


the pussycat dolls buttons, pussy cat dolls popular songs latest news of pussy cat,photos of pussy cat video of pussy cat tour dates and more of pussy cat bad romance exclusive video premiere a total of 555 full length pussy cat poker video pussy cat just dance video pussy cat myspace video pussy cat paparazzi video pussy cat, lovegame video pussy cat fame video pussy cat's sexy cinematic “paparazzi” video download v pop music singles watch music videos listen to free streaming mp3s read pussy cat's blog high quality ladygaga music videos for you to watch to embed into your page/profile or to discuss with video, The Pussycat Dolls performing the Stomp, Show me What You Got, in Manchester, on Feb. 04th, 2007,the, pussycat, dolls, show, me, what, you, got, stomp, live, in, manchester, pcd, nicole, scherzinger, carmit, melody, jessica, sutta


the pussycat dolls buttons, pussy cat dolls popular songs latest news of pussy cat,photos of pussy cat video of pussy cat tour dates and more of pussy cat bad romance exclusive video premiere a total of 555 full length pussy cat poker video pussy cat just dance video pussy cat myspace video pussy cat paparazzi video pussy cat, lovegame video pussy cat fame video pussy cat's sexy cinematic “paparazzi” video download v pop music singles watch music videos listen to free streaming mp3s read pussy cat's blog high quality ladygaga music videos for you to watch to embed into your page/profile or to discuss with video

Lady Gaga featuring Akon and Colby O'Donis - Just Dance

lady gaga, akon, colby o'donis, just dance, cherrytree, interscope, pop, dance

Lady Gaga ft. Space Cowboy, Flo Rida - Starstruck

Lady Gaga ft. Space Cowboy, Flo Rida - Starstrucklatest News of lady gaga, Photos of lady gaga, Video of lady gaga, Tour Dates and more of lady gaga, Bad Romance Exclusive Video Premiere, A total of 555 full length, high quality LadyGaga Music Videos for you to watch, to embed into your page/profile or to discuss with other music video, lady gaga poker video, lady gaga just dance video, lady gaga myspace video lady gaga paparazzi video, lady gaga lovegame video, lady gaga fame video, Lady Gaga's Sexy, Cinematic “Paparazzi” Video, Download Lady Gaga Pop music singles, watch music videos, listen to free streaming mp3s, read Lady Gaga's blog

Lady GaGa - Starstruck Feat. Flo Rida

Here is the download link: http://www.zshare.net/audio/513058809e5d0e10/ Lady GaGa - Starstruck Feat. Flo Rida I don't own any of this music ! Hope you enjoy it. (: Lyrics; Groove, Slam, Work it...Lady GaGa - Starstruck Feat. Flo Rida

Lady GaGa - Starstruck (ft. Flo Rida)


*WATCH IN HIGH QUALITY I have made a unofficial video from Lady GaGa,with the song ''Starstruck''. I used the video's ''Just Dance'' and ''Beautiful Dirty Rich'' for this video. I'm sorry for the...Lady GaGa - Starstruck (ft. Flo Rida)

Lady Gaga - Poker Face Remix

Lady Gaga - Poker Face Remix

igh quality LadyGaga Music Videos


Lady Gaga "The Fame" It's my first video. COMMENT+RATE+SUBSCRIBE !!! pls :P Made By Alex =) Lyrics: I can't help myself I'm addicted to a life of material It's some kind of joke I'm obsessively...lady, gaga, just, dance, lovegame, paparazzi, beautiful, dirty, rich, eh, nothing, else, can, say, poker, face, the, fame, money, honey, again, boys, brown, eyes, summerboy, like, it, rough, starstruck, paper, gangsta, disco, heaven, 2008, 2009, lyrics,latest News of lady gaga, Photos of lady gaga, Video of lady gaga, Tour Dates and more of lady gaga, Bad Romance Exclusive Video Premiere, A total of 555 full length, high quality LadyGaga Music Videos for you to watch, to embed into your page/profile or to discuss with other music video, lady gaga poker video, lady gaga just dance video, lady gaga myspace video lady gaga paparazzi video, lady gaga lovegame video, lady gaga fame video, Lady Gaga's Sexy, Cinematic “Paparazzi” Video, Download Lady Gaga Pop music singles, watch music videos, listen to free streaming mp3s, read Lady Gaga's blog


Listen to this song! This beat is so addictive! [LYRICS]: Groove. Slam. Work it back. Filter that. Baby bump that track. Groove. Slam. Work it back. Filter that. Baby bump that track. Groove....lady, gaga, poker, face, pokerface, idol, live, lovegame, love, game, official, music, video, new, single, song, just, dance, lyrics, starstruck, eh, nothing, else, can, say, the, fame, paparazzi, 2009, quicksand, britney, spears, womanizer, circus, if, you, seek, amy, out, from, under, starring, world, tour, performance, trouble, amnesia

lady gaga christmas tree


NO NEED TO TAKE THIS DOWN YOUTUBE! IM JUST A HUGE GAGA FA AND LOVE HER AND PUTTING THIS VIDEO UP TO SHOW MY SUPPORT OF HER AND SO OTHER FANS CAN LISTEN TO HER AMAZING MUSIC!! IM NOT DOING ANY HARM! IM...lady gaga christmas tree, world, premiere, xmas, song, (hq), video, ft, space, cowboy, new, singer, best, music, justdance, just, dance, pokerface, beautiful, dirty, rich, the, fame, love, games, starstruck, hot, sexy, tunes, 2008, december, 2nd, 2009, still, loving, it

beautiful dirty rich


lady gaga, beautiful dirty rich, dirty sexy money, just dance, poker face

Space Cowboy and Flo Rida


Lady Gaga Starstruck Ft. Space Cowboy and Flo Rida COMMENT+RATE+SUBSCRIBE !!! Lyrics: Groove. Slam. Work it back. Filter that. Baby bump that track. Groove. Slam. Work it back. Filter that. Baby bump...lady, gaga, just, dance, lovegame, paparazzi, beautiful, dirty, rich, eh, nothing, else, can, say, poker, face, the, fame, money, honey, again, boys, brown, eyes, summerboy, like, it, rough, starstruck, paper, gangsta, disco, heaven, 2008, 2009, lyrics

lady gaga, poker face, just dance, paparazzi


lady gaga, poker face, just dance, paparazzi

watch music videos of lady gaga


latest News of lady gaga, Photos of lady gaga, Video of lady gaga, Tour Dates and more of lady gaga, Bad Romance Exclusive Video Premiere, A total of 555 full length, high quality LadyGaga Music Videos for you to watch, to embed into your page/profile or to discuss with other music video, lady gaga poker video, lady gaga just dance video, lady gaga myspace video lady gaga paparazzi video, lady gaga lovegame video, lady gaga fame video, Lady Gaga's Sexy, Cinematic “Paparazzi” Video, Download Lady Gaga Pop music singles, watch music videos, listen to free streaming mp3s, read Lady Gaga's blog

Video of lady gaga

http://www.youtube.com/watch?v=QgKrzdaDQMw


latest News of lady gaga, Photos of lady gaga, Video of lady gaga, Tour Dates and more of lady gaga, Bad Romance Exclusive Video Premiere, A total of 555 full length, high quality LadyGaga Music Videos for you to watch, to embed into your page/profile or to discuss with other music video, lady gaga poker video, lady gaga just dance video, lady gaga myspace video lady gaga paparazzi video, lady gaga lovegame video, lady gaga fame video, Lady Gaga's Sexy, Cinematic “Paparazzi” Video, Download Lady Gaga Pop music singles, watch music videos, listen to free streaming mp3s, read Lady Gaga's blog

lady gaga hot video


lady gaga hot video

Indian POP - Old is Gold


hindi pop song,old is gold, popular old songs,indian old songs

Hindi pop song- Ghar Jay


hindi pop song remix, Ghar Jay mix, popular remix songs, indian remix, indian songs

Hindi pop song - ADNAN - KABHI TO NAJAR MILAO

hindi pop song, adnan kabhi to najar milao, remix songs

chadti jawani


chadti, jawani, hindi, pop,chadti jawani, hindi songs

hindi pop song, sonu kuch tum socho


hindi pop song, sonu kuch tum socho

popular remix songs


hindi pop song remix, mera babu chail chaliba mix, popular remix songs, indian remix, indian songs

Rangraliyan, Superb Sound Quality, Bollywood Top 13, Hindi Pop, Hindi Music


Rangraliyan, Superb Sound Quality, Bollywood Top 13, Hindi Pop, Hindi Music,Rangraliyan, Superb Sound Quality, Bollywood Top 13, Hindi Pop, Hindi Music

Gorenaal Ishq Mita HQ

Gorenaal Ishq Mita HQ

gorenaal ishq mita, bally sagoo, bollywood and hindi pop models, models video and songs, hits album, dance, best awesome song

popular bollywood songs


Hindi Songs PoP Remix, popular Hindi Songs PoP Remix, popular songs, indian popular songs, popular bollywood songs

Gori Teri Ankhen kahe


A very nice hindi pop song,Gori Teri Ankhen kahe,gori teri aankhen, kahe raat bhar, soi nahi nice hindi romantic, sad pop song, bollywood songs,bollywood popular songs, bollywood songs remix

Paddle Pop - Cyberion Part I of IV (Hindi)


Fantastic animation film from the makers of Quality Walls ice creams, in India. Language: Hindi. Kids love it.paddle, pop, cyberion, animation, hindi, quality, walls, kids, tubu, nishaad, souvik, paddle pop cyberion animation, hindi quality walls, kids tubu, nishaad souvik ishita,quality animation,funny animation

Jaaniye Dus Kahaniya


DUS KAHANIYAN REMIX SONG hindi pop rock world kool desi bhangra india tere ma ke choot bund maro kuta kuti,dus kahaniyan remix song, hindi pop rock song, world kool desi bhangra, india tere ma ke, choot bund maro kuta,indian remix

Hindi pop song - Mera Babu.Chail Chaliba Mix


hindi pop song, mera babu chail chaliba mix, popular remix songs, indian remix, indian songs,Hindi pop song - Mera Babu.Chail Chaliba Mix

timi maya gara ya nagar (nepali film song)

nepali film songs, parkhibasen songs,nepali flim trialers,nepali flim video, video of nepal,flimy video of nepal

new nepali love song of prashna shakya jaha jaha of her new album udayan


prashna shakya jaha udayan, nepal songs, nepali songs, nepalese song and music, folk dohori culture pop songs, rock and love songs, video of kathmandu, beni bazar myagdi songs, latest lok and modern rap movie, hip hop film, jyamrukot baglung dhaulagiri pokhara songs, everest mechi mahakal kali gandaki remix, new official

मन छाडे मौच्याङलाई..Prashna Shakya, Milan Surkheti & Dj LX.


Man Chhade.. Album:-"Target" Danny Denzongpa & Nirmala Gajmer. Milan Surkheti & Prashna Shakya Dj Lx. Nepali Pop Hip Hop Remix Song,nepali, pop, hip, hop, remix, song, prashna, shakya, dj, lx, durungchunge, magar,nepali pop, hip hop remix song, prashna shakya dj songs, lx durungchunge magar, nepali popular songs and remix

nepali hit songs


nepal best song collection, hit songs of nepal, nepali hit songs,

rajesh and kamana songs


its a really nice song from the new album of rajesh payal rai-kamana,rajaesh payal rai songs, kamana songs, rajesh and kamana songs, popular songs of rajesh payal rai

नेपाली गीत:Rajesh Payal Rai/Anju Pant:-खोज्दै आए...


नेपाली गीत,khojdai aaye, som thapa magar and rajesh payal rai and anju pant music and songs, dinesh subba songs, nepali folk songs, modern pop song, adhunik geet, tanahunge nepal

नेपाली गीत:Rajesh Payal Rai/Anju Pant:-खोज्दै आए...


नेपाली गीत,khojdai aaye, som thapa magar and rajesh payal rai and anju pant music and songs, dinesh subba songs, nepali folk songs, modern pop song, adhunik geet, tanahunge nepal

nepali popular songs


nepali popular songs

song by rajesh payal rai & malika karki juna manga


juna manga, rajesh payal rai songs, malika karki songs,song by rajesh payal rai & malika karki juna manga, nepali songs, nepali popular songs, hit songs of nepal, nepali loggeet

Monday, December 21, 2009

Taylor Swift - Parody - You Belong With Me ("Just A Zombie")

music, video, by, taylor, swift, performing, you, belong, with, me, 2009, big, machine, records, llc, parody, spoof, official, love, story, white, horse, fearless, pop, country, joe, jonas, miley, cyrus, hannah, montana, disney, star, lady, gaga, number, one, female, on, youtube, venetianprincess

Taylor Swift - Fifteen: Close Captioned

taylor, swift, fifteen, country, open, road, recordings, randy, brewer, [video, producer], roman, white, director], norman, bonney, [cinematographer], darla, korieba, editor]

Taylor Swift - You Belong With Me: Closed-Captioned

Music video by Taylor Swift performing You Belong With Me: Closed-Captioned with Roman White [Video Director], Mandy Brewer [Video Producer]

You are beautiful videos



chester, see, god, damn, you're, beautiful, disney, 365, jonathan, nellis,you are baeutiful video
james blunt joe cocker mika kellie pickler chester see james blunt live

Javascript tutorial making resizable and draggable DIVs


How to create resizable and draggable DIVs with javascript http://melvinjr.wallsinc.com/tuts/resizeDragsrc.html
javascript, pbj, enash131, html, css, cool, tutorial, video, mootools, moo, tools, resize, drag, js,javascript video, html video, css video, cool tutorial video of javascript, tools resize and drag video, js video,How to create resizable and draggable DIVs video

earn how to create a website using HTML and CSS video, css video


css, template, make, website, html Download template @ http://www.2createawebsite.com/design/csstemplate.zip and learn how to create a website using HTML and CSS video, css video, template video, make video, website video, html Download template video,How to Make a Website With CSS - Free Template

Javascript Tutorial Changing Image Using Dropdown


Javascript Tutorial video, Changing Image Using Dropdown video, Javascript Tutorial Changing Image Using Dropdown video, This tutorial goes over using a dropdown to change the source of an image,javascript video, tutorial video, js video,dropdown image video

CSS Tutorial, Div Layers, Classes


css, tutorial, youtube, video, div, layer, class, id, sources, doodleflash, science, technology, php, style css video, css tutorial video, div video, layer video, class video, id video, sources video, doodleflash video, science video, technology video, php video, style video

A PHP Tutorial creating a User Login and Setting Cookies.


php, tutorial, sql, video, css, user, login, cookies, lifeg0eson666, marcus, recck, youtube, online, science, A PHP Tutorial creating a User Login and Setting Cookies video.

PLEASE CHECK OUT THE SECOND VIDEO OF THIS A quick and easy user registration using php, sql and phpmyadmin. For full size and source codes: http://www.neoblob.com/phpsquad/tuts/php/1/ SQL: CREATE...
tutorial, php, sql, mysql, phpmyadmin,computers, video, sexy tutorial, php video, sql video, mysql video, phpmyadmin video, computers video, video, registration video using php

php basic video


This PHP tutorial covers the echo, the if...else statement and integer variables. A more in depth written tutorial shall be available on my website soon
php, tutorial, if, else, variable, basic of php and mysql video, php video, php basic video

login using php video


This PHP tutorial elaborates on my second PHP tutorial which covers authentication. This PHP tutorial covers a more advanced PHP script which allow/denies users access to a specific website.
php tutorial best login form videos,php tutorial videos, login form video, rascal999, php, tutorial, if, authenticate, authentication, login, password, form, variable, basic, mysql, sql,authentication video, user access video, website video,login using php video

Php and mysql videos



Source Files - http://www.developphp.com In this Flash ActionScript 3.0, PHP, and MySQL tutorial video and source file download you can learn how to build slick CMS(Content Management Systems) for...
flash, cms, tutorial, actionscript, 3.0, cs3, cs4, php, mysql, database, edit, website, content, management, system, change, client, text, field, login, password, flashbuilding, site,
cms using php and mysql, webdesigning with php and mysql,php and mysql videos, video tutorial of php,php videos, mysql videos

An A-Z Index of the Windows XP command line

An A-Z Index of the Windows XP command line
ADDUSERS Add or list users to/from a CSV file
ARP Address Resolution Protocol
ASSOC Change file extension associations•
ASSOCIAT One step file association
AT Schedule a command to run at a later time
ATTRIB Change file attributes
b
BOOTCFG Edit Windows boot settings
BROWSTAT Get domain, browser and PDC info
c
CACLS Change file permissions
CALL Call one batch program from another•
CD Change Directory - move to a specific Folder•
CHANGE Change Terminal Server Session properties
CHKDSK Check Disk - check and repair disk problems
CHKNTFS Check the NTFS file system
CHOICE Accept keyboard input to a batch file
CIPHER Encrypt or Decrypt files/folders
CleanMgr Automated cleanup of Temp files, recycle bin
CLEARMEM Clear memory leaks
CLIP Copy STDIN to the Windows clipboard.
CLS Clear the screen•
CLUSTER Windows Clustering
CMD Start a new CMD shell
COLOR Change colors of the CMD window•
COMP Compare the contents of two files or sets of files
COMPACT Compress files or folders on an NTFS partition
COMPRESS Compress individual files on an NTFS partition
CON2PRT Connect or disconnect a Printer
CONVERT Convert a FAT drive to NTFS.
COPY Copy one or more files to another location•
CSCcmd Client-side caching (Offline Files)
CSVDE Import or Export Active Directory data
d
DATE Display or set the date•
Dcomcnfg DCOM Configuration Utility
DEFRAG Defragment hard drive
DEL Delete one or more files•
DELPROF Delete NT user profiles
DELTREE Delete a folder and all subfolders
DevCon Device Manager Command Line Utility
DIR Display a list of files and folders•
DIRUSE Display disk usage
DISKCOMP Compare the contents of two floppy disks
DISKCOPY Copy the contents of one floppy disk to another
DISKPART Disk Administration
DNSSTAT DNS Statistics
DOSKEY Edit command line, recall commands, and create macros
DSADD Add user (computer, group..) to active directory DSQUERY List items in active directory
DSMOD Modify user (computer, group..) in active directory
e
ECHO Display message on screen•
ENDLOCAL End localisation of environment changes in a batch file•
ERASE Delete one or more files•
EXIT Quit the current script/routine and set an errorlevel•
EXPAND Uncompress files
EXTRACT Uncompress CAB files
f
FC Compare two files
FIND Search for a text string in a file
FINDSTR Search for strings in files
FOR /F Loop command: against a set of files•
FOR /F Loop command: against the results of another command•
FOR Loop command: all options Files, Directory, List•
FORFILES Batch process multiple files
FORMAT Format a disk
FREEDISK Check free disk space (in bytes)
FSUTIL File and Volume utilities
FTP File Transfer Protocol
FTYPE Display or modify file types used in file extension associations•
g
GLOBAL Display membership of global groups
GOTO Direct a batch program to jump to a labelled line•
h
HELP Online Help
i
iCACLS Change file and folder permissions
IF Conditionally perform a command•
IFMEMBER Is the current user in an NT Workgroup
IPCONFIG Configure IP
k
KILL Remove a program from memory
l
LABEL Edit a disk label
LOCAL Display membership of local groups
LOGEVENT Write text to the NT event viewer.
LOGOFF Log a user off
LOGTIME Log the date and time in a file
m
MAPISEND Send email from the command line
MBSAcli Baseline Security Analyzer.
MEM Display memory usage
MD Create new folders•
MKLINK Create a symbolic link (linkd)
MODE Configure a system device
MORE Display output, one screen at a time
MOUNTVOL Manage a volume mount point
MOVE Move files from one folder to another•
MOVEUSER Move a user from one domain to another
MSG Send a message
MSIEXEC Microsoft Windows Installer
MSINFO Windows NT diagnostics
MSTSC Terminal Server Connection (Remote Desktop Protocol)
MUNGE Find and Replace text within file(s)
MV Copy in-use files
n
NET Manage network resources
NETDOM Domain Manager
NETSH Configure network protocols
NETSVC Command-line Service Controller
NBTSTAT Display networking statistics (NetBIOS over TCP/IP)
NETSTAT Display networking statistics (TCP/IP)
NOW Display the current Date and Time
NSLOOKUP Name server lookup
NTBACKUP Backup folders to tape
NTRIGHTS Edit user account rights
p
PATH Display or set a search path for executable files•
PATHPING Trace route plus network latency and packet loss
PAUSE Suspend processing of a batch file and display a message•
PERMS Show permissions for a user
PERFMON Performance Monitor
PING Test a network connection
POPD Restore the previous value of the current directory saved by PUSHD•
PORTQRY Display the status of ports and services
PRINT Print a text file
PRNCNFG Display, configure or rename a printer
PRNMNGR Add, delete, list printers set the default printer
PROMPT Change the command prompt•
PsExec Execute process remotely
PsFile Show files opened remotely
PsGetSid Display the SID of a computer or a user
PsInfo List information about a system
PsKill Kill processes by name or process ID
PsList List detailed information about processes
PsLoggedOn Who's logged on (locally or via resource sharing)
PsLogList Event log records
PsPasswd Change account password
PsService View and control services
PsShutdown Shutdown or reboot a computer
PsSuspend Suspend processes
PUSHD Save and then change the current directory•
q
QGREP Search file(s) for lines that match a given pattern.
r
RASDIAL Manage RAS connections
RASPHONE Manage RAS connections
RECOVER Recover a damaged file from a defective disk.
REG Registry: Read, Set, Export, Delete keys and values
REGEDIT Import or export registry settings
REGSVR32 Register or unregister a DLL
REGINI Change Registry Permissions
REM Record comments (remarks) in a batch file•
REN Rename a file or files•
REPLACE Replace or update one file with another
RD Delete folder(s)•
RMTSHARE Share a folder or a printer
ROBOCOPY Robust File and Folder Copy
ROUTE Manipulate network routing tables
RUNAS Execute a program under a different user account
RUNDLL32 Run a DLL command (add/remove print connections)
s
SC Service Control
SCHTASKS Create or Edit Scheduled Tasks
SCLIST Display NT Services
SET Display, set, or remove environment variables•
SETLOCAL Control the visibility of environment variables•
SETX Set environment variables permanently
SHARE List or edit a file share or print share
SHIFT Shift the position of replaceable parameters in a batch file•
SHORTCUT Create a windows shortcut (.LNK file)
SHOWGRPS List the NT Workgroups a user has joined
SHOWMBRS List the Users who are members of a Workgroup
SHUTDOWN Shutdown the computer
SLEEP Wait for x seconds
SOON Schedule a command to run in the near future
SORT Sort input
START Start a program or command in a separate window•
SU Switch User
SUBINACL Edit file and folder Permissions, Ownership and Domain
SUBST Associate a path with a drive letter
SYSTEMINFO List system configuration
t
TASKLIST List running applications and services
TASKKILL Remove a running process from memory
TIME Display or set the system time•
TIMEOUT Delay processing of a batch file
TITLE Set the window title for a CMD.EXE session•
TLIST Task list with full path
TOUCH Change file timestamps
TRACERT Trace route to a remote host
TREE Graphical display of folder structure
TYPE Display the contents of a text file•
u
USRSTAT List domain usernames and last login
v
VER Display version information•
VERIFY Verify that files have been saved•
VOL Display a disk label•
w
WHERE Locate and display files in a directory tree
WHOAMI Output the current UserName and domain
WINDIFF Compare the contents of two files or sets of files
WINMSD Windows system diagnostics
WINMSDP Windows system diagnostics II
WMIC WMI Commands
x
XCACLS Change file and folder permissions
XCOPY Copy files and folders
:: Comment / Remark•
Commands marked • are Internal commands only available within the CMD shell.
All other commands (NOT marked with •) are external commands which may be used under the CMD shell, PowerShell, or directly from START-RUN.

An A-Z Index of the Windows XP command line

An A-Z Index of the Windows XP command line
ADDUSERS Add or list users to/from a CSV file
ARP Address Resolution Protocol
ASSOC Change file extension associations•
ASSOCIAT One step file association
AT Schedule a command to run at a later time
ATTRIB Change file attributes
b
BOOTCFG Edit Windows boot settings
BROWSTAT Get domain, browser and PDC info
c
CACLS Change file permissions
CALL Call one batch program from another•
CD Change Directory - move to a specific Folder•
CHANGE Change Terminal Server Session properties
CHKDSK Check Disk - check and repair disk problems
CHKNTFS Check the NTFS file system
CHOICE Accept keyboard input to a batch file
CIPHER Encrypt or Decrypt files/folders
CleanMgr Automated cleanup of Temp files, recycle bin
CLEARMEM Clear memory leaks
CLIP Copy STDIN to the Windows clipboard.
CLS Clear the screen•
CLUSTER Windows Clustering
CMD Start a new CMD shell
COLOR Change colors of the CMD window•
COMP Compare the contents of two files or sets of files
COMPACT Compress files or folders on an NTFS partition
COMPRESS Compress individual files on an NTFS partition
CON2PRT Connect or disconnect a Printer
CONVERT Convert a FAT drive to NTFS.
COPY Copy one or more files to another location•
CSCcmd Client-side caching (Offline Files)
CSVDE Import or Export Active Directory data
d
DATE Display or set the date•
Dcomcnfg DCOM Configuration Utility
DEFRAG Defragment hard drive
DEL Delete one or more files•
DELPROF Delete NT user profiles
DELTREE Delete a folder and all subfolders
DevCon Device Manager Command Line Utility
DIR Display a list of files and folders•
DIRUSE Display disk usage
DISKCOMP Compare the contents of two floppy disks
DISKCOPY Copy the contents of one floppy disk to another
DISKPART Disk Administration
DNSSTAT DNS Statistics
DOSKEY Edit command line, recall commands, and create macros
DSADD Add user (computer, group..) to active directory DSQUERY List items in active directory
DSMOD Modify user (computer, group..) in active directory
e
ECHO Display message on screen•
ENDLOCAL End localisation of environment changes in a batch file•
ERASE Delete one or more files•
EXIT Quit the current script/routine and set an errorlevel•
EXPAND Uncompress files
EXTRACT Uncompress CAB files
f
FC Compare two files
FIND Search for a text string in a file
FINDSTR Search for strings in files
FOR /F Loop command: against a set of files•
FOR /F Loop command: against the results of another command•
FOR Loop command: all options Files, Directory, List•
FORFILES Batch process multiple files
FORMAT Format a disk
FREEDISK Check free disk space (in bytes)
FSUTIL File and Volume utilities
FTP File Transfer Protocol
FTYPE Display or modify file types used in file extension associations•
g
GLOBAL Display membership of global groups
GOTO Direct a batch program to jump to a labelled line•
h
HELP Online Help
i
iCACLS Change file and folder permissions
IF Conditionally perform a command•
IFMEMBER Is the current user in an NT Workgroup
IPCONFIG Configure IP
k
KILL Remove a program from memory
l
LABEL Edit a disk label
LOCAL Display membership of local groups
LOGEVENT Write text to the NT event viewer.
LOGOFF Log a user off
LOGTIME Log the date and time in a file
m
MAPISEND Send email from the command line
MBSAcli Baseline Security Analyzer.
MEM Display memory usage
MD Create new folders•
MKLINK Create a symbolic link (linkd)
MODE Configure a system device
MORE Display output, one screen at a time
MOUNTVOL Manage a volume mount point
MOVE Move files from one folder to another•
MOVEUSER Move a user from one domain to another
MSG Send a message
MSIEXEC Microsoft Windows Installer
MSINFO Windows NT diagnostics
MSTSC Terminal Server Connection (Remote Desktop Protocol)
MUNGE Find and Replace text within file(s)
MV Copy in-use files
n
NET Manage network resources
NETDOM Domain Manager
NETSH Configure network protocols
NETSVC Command-line Service Controller
NBTSTAT Display networking statistics (NetBIOS over TCP/IP)
NETSTAT Display networking statistics (TCP/IP)
NOW Display the current Date and Time
NSLOOKUP Name server lookup
NTBACKUP Backup folders to tape
NTRIGHTS Edit user account rights
p
PATH Display or set a search path for executable files•
PATHPING Trace route plus network latency and packet loss
PAUSE Suspend processing of a batch file and display a message•
PERMS Show permissions for a user
PERFMON Performance Monitor
PING Test a network connection
POPD Restore the previous value of the current directory saved by PUSHD•
PORTQRY Display the status of ports and services
PRINT Print a text file
PRNCNFG Display, configure or rename a printer
PRNMNGR Add, delete, list printers set the default printer
PROMPT Change the command prompt•
PsExec Execute process remotely
PsFile Show files opened remotely
PsGetSid Display the SID of a computer or a user
PsInfo List information about a system
PsKill Kill processes by name or process ID
PsList List detailed information about processes
PsLoggedOn Who's logged on (locally or via resource sharing)
PsLogList Event log records
PsPasswd Change account password
PsService View and control services
PsShutdown Shutdown or reboot a computer
PsSuspend Suspend processes
PUSHD Save and then change the current directory•
q
QGREP Search file(s) for lines that match a given pattern.
r
RASDIAL Manage RAS connections
RASPHONE Manage RAS connections
RECOVER Recover a damaged file from a defective disk.
REG Registry: Read, Set, Export, Delete keys and values
REGEDIT Import or export registry settings
REGSVR32 Register or unregister a DLL
REGINI Change Registry Permissions
REM Record comments (remarks) in a batch file•
REN Rename a file or files•
REPLACE Replace or update one file with another
RD Delete folder(s)•
RMTSHARE Share a folder or a printer
ROBOCOPY Robust File and Folder Copy
ROUTE Manipulate network routing tables
RUNAS Execute a program under a different user account
RUNDLL32 Run a DLL command (add/remove print connections)
s
SC Service Control
SCHTASKS Create or Edit Scheduled Tasks
SCLIST Display NT Services
SET Display, set, or remove environment variables•
SETLOCAL Control the visibility of environment variables•
SETX Set environment variables permanently
SHARE List or edit a file share or print share
SHIFT Shift the position of replaceable parameters in a batch file•
SHORTCUT Create a windows shortcut (.LNK file)
SHOWGRPS List the NT Workgroups a user has joined
SHOWMBRS List the Users who are members of a Workgroup
SHUTDOWN Shutdown the computer
SLEEP Wait for x seconds
SOON Schedule a command to run in the near future
SORT Sort input
START Start a program or command in a separate window•
SU Switch User
SUBINACL Edit file and folder Permissions, Ownership and Domain
SUBST Associate a path with a drive letter
SYSTEMINFO List system configuration
t
TASKLIST List running applications and services
TASKKILL Remove a running process from memory
TIME Display or set the system time•
TIMEOUT Delay processing of a batch file
TITLE Set the window title for a CMD.EXE session•
TLIST Task list with full path
TOUCH Change file timestamps
TRACERT Trace route to a remote host
TREE Graphical display of folder structure
TYPE Display the contents of a text file•
u
USRSTAT List domain usernames and last login
v
VER Display version information•
VERIFY Verify that files have been saved•
VOL Display a disk label•
w
WHERE Locate and display files in a directory tree
WHOAMI Output the current UserName and domain
WINDIFF Compare the contents of two files or sets of files
WINMSD Windows system diagnostics
WINMSDP Windows system diagnostics II
WMIC WMI Commands
x
XCACLS Change file and folder permissions
XCOPY Copy files and folders
:: Comment / Remark•
Commands marked • are Internal commands only available within the CMD shell.
All other commands (NOT marked with •) are external commands which may be used under the CMD shell, PowerShell, or directly from START-RUN.

Friday, December 18, 2009

Earn online dollars













This is not joke just click the link below

and start to earn from today sign up is free


Thursday, December 17, 2009

17th Dec 2009

To,
The HR manager
Everest Bank Ltd
New Baneshwor, Kathmandu

Subject: Regarding the internship provision

Respected sir/madam,

As a potential intern, with required qualification and a strong desire to excel in banking profession, I am seeking to align myself as an intern with a company that ranks top at the global market and also offers internship to undergraduates like me.
I am seeking a professional opportunity where my educational and other co-curricular experiences can benefit your company as well as lead me to my career goal and drive me along my career path.

I keep forth my kind request to consider my application for internship for internship at your bank for a period of six weeks which is a must for the course of BCIS(Bachelor in computer information system) under Pokhara University. As under the university norms, we are supposed to select the specialized subject in final year and I have decided to take part in IT sector. This opportunity will help me to explore more during my classes and learn more.

I assure you that I will strongly adhere to the bank norms and rules during my tenure as an intern and at any time in the future. I will also fulfill my responsibilities with utmost dedication if given any.

I wait for your positive response.

Thanking you.

Yours sincerely,
Rupak Nepali
BCIS 7th semester
Nobel College

internship letter, cover letter, intern letter, letter of internship,

Sunday, December 13, 2009

Loadsheding in Nepal schedule




Loadsheding in Nepal schedule,loadshedding schedule in nepal, nepal electricity authority, nepal schedule of light, light schedule loadshedding,light loadshedding in nepal from 2009/12/14 2066/08/27

all questions are for Oracle practice

Write down the SQL statements for the following.

  1. select all information from emp;
  2. list all employee who have salary between 2000 and 5500.
  3. List department numbers and names in department name order;
  4. Display all the different job types.
  5. List the details of the employees in departments 10 and 20 in alphabetical order of name.
  6. List names and jobs of all clerks in department 20.
  7. Display all employees names which have TH or LL in them.
  8. List all employees who have a manager.
  9. Display name and total remuneration for all employee.
  10. Display all employee who were hired during 1981.
  11. Find the minimum salary of all employees.
  12. Find the minimum, maximum and average salaries of all employees of department 20.
  13. List the minimum and maximum salary for each job type.
  14. Find out how many managers there are without listing them.
  15. Find the average salary and average total remuneration for each job type. Remember salesmen earn commission.
  16. Find out the difference between highest and lowest salaries.
  17. Find all departments which have more than 3 employees.
  18. List lowest paid employees working for each manager. Exclude any groups where the minimum salary is less then 1000. Sort the output by salary.
  19. Display all employee names and their department name, in department name order.
  20. Display all employee names, department number and names.
  21. Display the name, location and department of employees whose salary is more than 1500 a month.
  22. Produce a list showing employees salary grades.
  23. Show only employees on Grade 3.
  24. Show all employees in ‘Dallas’.
  25. List the employee name, job, salary, grade and department name for everyone in the company except clerks. Sort on salary, displaying the highest salary first.
  26. List ename, job, annual_sal, deptno, dname, grade from emp, dept and salgrade table who earn 36000 a year or who are ‘clerks’.
  27. Display the department that has not employees.
  28. List all employees by name and number along with their manager’s name and number.
  29. Modify solution to question 2 to display IND who has no manager.
  30. Find all employees who joined the company before their manager.
  31. Find the job that was filled in the first half of 1983, and the same job that was filled during the same period in 1984.