<?
include 'db_connect.php';
    $n = mysql_query("SELECT * FROM applications WHERE type ='titul'");
    for ($i=0; $i<mysql_num_rows($n); $i++) {
      echo "<tr>";
      $num = mysql_fetch_array($n);
      $dogs = mysql_query("SELECT * FROM dogs WHERE user_id='$num[user_id]'");
      $d = mysql_fetch_array($dogs);
      $owner = mysql_query("SELECT 'certificate_application.dog_id', 'certificate_application.user_id', 'certificate_application.app_id', 'certificate_application.certificate', 'users.user_name', 'dogs.dog_name'