<!-- //jerry/index.php -->

$connection_mysql = mysqli_connect("localhost","myname","mypass","mydatabase");
   
   if (mysqli_connect_errno($connection_mysql)){
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
   }
 
     echo "Select statement follows:" ;
   $sql = "SELECT * FROM tblClients \\WHERE ClientID = ClientID";
   echo("<table>");
   if ($result = mysqli_query($connection_mysql,$sql)){
      while ($row = mysqli_fetch_row($result)){
         printf ("%s %s %s %s %s %s %s %s %s %s/         %s %s %s %s %s %s %s %s %s %s %s %s %s
         %s %s %s %s %s %s %s %s %s %s %s %s (%s)<br><br>\n ",
         $row[0], $row[1], $row[2], $row[3], $row[4], $row[5], $row[6], $row[7], $row[8], $row[9], $row[10], 
         $row[11], $row[12], $row[13], $row[14], $row[15], $row[16], $row[17], $row[18], $row[19], $row[20], 
         $row[21], $row[22], $row[23], $row[24], $row[25], $row[26], $row[27], $row[28], $row[29], $row[30], 
         $row[31], $row[32], $row[33], $row[34], $row[35], $row[36], $row[37], $row[38], $row[39], $row[40]);
          
      }
     
      
      mysqli_free_result($result);// clear result set
   }
   mysqli_close($connection_mysql);

$mysqli -> close();


?>