Advertisement
Guest User

Untitled

a guest
Jul 28th, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.24 KB | None | 0 0
  1. <?PHP
  2. include ("var_inc.php");
  3. $query1="SELECT city, newzone FROM zones";
  4. $result1=mysql_query($query1, $db_conn);
  5. $c1=mysql_num_rows($result1);
  6. echo "<html><body><table border='1' cellspacing='0' cellpadding='0'>";
  7. for($i1=0;$i1<$c1;$i1++)
  8.     {
  9.     $row1=mysql_fetch_array($result1);
  10.     $query2="SELECT city, newzone FROM zones";
  11.     $result2=mysql_query($query2, $db_conn);
  12.     $c2=mysql_num_rows($result2);
  13.     if($i1==0)
  14.         {
  15.         echo "<tr><td>&nbsp;</td>";
  16.         for($i4=0;$i4<$c1;$i4++)
  17.             {
  18.             $row4=mysql_fetch_array($result2);
  19.             echo "<td>".$row4[0]."</td>";
  20.             }
  21.         echo "</tr>";
  22.         }
  23.     echo "<tr><td>".$row1[0]."</td>";
  24.     for($i2=0;$i2<$c2;$i2++)
  25.         {
  26.         $row2=mysql_fetch_array($result2);
  27.         $zones=array();
  28.         $zones[0]=$row1[1];
  29.         $zones[1]=$row2[1];
  30.         sort($zones);
  31.         if($zones[0] == 999 || $zones[1] == 999)
  32.             {
  33.             echo "<td>&nbsp;</td>";
  34.             }
  35.         else
  36.             {
  37.             $query3="SELECT breg FROM newnewjay WHERE fromzone='".$zones[0]."' AND tozone='".$zones[1]."'";
  38.             $result3=mysql_query($query3, $db_conn);
  39.             $c3=mysql_num_rows($result3);
  40.             $row3=mysql_fetch_array($result3);
  41.             print_r($row1);
  42.             echo "<br>";
  43.             echo "<td>z1=".$row1[1].",z2=".$zones[1].",p=".$row3[0]."</td>";
  44.             }
  45.         }
  46.     echo "</tr>";
  47.     }
  48. echo "</table></body></html>";
  49. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement