Example:

<?php
    //  creatingconnection with mysql database server
  
    $con = mysql_connect("localhost", "root", "root");
    // check connection is establish or not
    if(!$con)
    {
        die ("Connectionnot established!  Please try again");
    }
  
    echo '<b>Connection successfully open</b>'.'</br>';
    // selecting database 
     mysql_select_db("MySqlDatabase", $con);
    //  selectingrecord
    $qry = "Select * from mysqldatabse.tbllogin";
  
    //  printselecting record
    $qryResult= mysql_query($qry);
  
     while ($row =  mysql_fetch_array($qryResult))
    {
         echo $row['Name'].'   '.$row['EmailId'].'   '.$row['Password'];
         echo '</br>';
    }
  
    //  Closingthe connection
  
     mysql_close($con);
     echo '<b>Connection closed successfully</b>';
?>

Note: mysql_query() function sends a unique query (multiple queries are not supported) to the currently active database on the server that's associated with the specified link_identifier and mysql_fetch_array() function returns an array that corresponds to the fetched row and moves the internal data pointer ahead.

Output:

Note: ‘*’ is used for selecting all records from table.

You can select specific column record.

<?php
    //  creatingconnection with mysql database server
  
    $con = mysql_connect("localhost", "root", "root");
    // check connection is establish or not
    if(!$con)
    {
        die ("Connectionnot established!  Please try again");
    }
  
    echo '<b>Connection successfully open</b>'.'</br>';
    // selecting database 
     mysql_select_db("MySqlDatabase", $con);
    //  selectingrecord with specified column name
    $qry = "Select Name,EmailId,Password from mysqldatabse.tbllogin";
  
    $qryResult= mysql_query($qry);
    //  printselecting record
     while ($row =  mysql_fetch_array($qryResult))
    {
         print_r($row);
         echo '</br>';
    }
    //Closingthe connection
     mysql_close($con);
     echo '<b>Connection closed successfully</b>';
?>

Note: print_r() function is used for print array.

Output:

Example: Selecting record with ‘where’ clause

<?php
    //  creatingconnection with mysql database server
  
    $con = mysql_connect("localhost", "root", "root");
    // check connection is establish or not
    if(!$con)
    {
        die ("Connectionnot established!  Please try again");
    }
  
    echo '<b>Connection successfully open</b>'.'</br>';
    // selecting database 
     mysql_select_db("MySqlDatabase", $con);
    //  selectingrecord with where clause
    $qry = "Select Password from mysqldatabse.tbllogin where EmailId ='arunsingh@yahoomail.com'";
  
    $qryResult= mysql_query($qry);
    //  printselecting record
     while ($row =  mysql_fetch_array($qryResult))
    {
        echo 'Password is : '.$row['Password'];
         echo '</br>';
    }
    //Closingthe connection
     mysql_close($con);
     echo '<b>Connection closed successfully</b>';
?>

Output: