Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?PHP
- include ("var_inc.php");
- $query1="SELECT city, newzone FROM zones";
- $result1=mysql_query($query1, $db_conn);
- $c1=mysql_num_rows($result1);
- echo "<html><body><table border='1' cellspacing='0' cellpadding='0'>";
- for($i1=0;$i1<$c1;$i1++)
- {
- $row1=mysql_fetch_array($result1);
- $query2="SELECT city, newzone FROM zones";
- $result2=mysql_query($query2, $db_conn);
- $c2=mysql_num_rows($result2);
- if($i1==0)
- {
- echo "<tr><td> </td>";
- for($i4=0;$i4<$c1;$i4++)
- {
- $row4=mysql_fetch_array($result2);
- echo "<td>".$row4[0]."</td>";
- }
- echo "</tr>";
- }
- echo "<tr><td>".$row1[0]."</td>";
- for($i2=0;$i2<$c2;$i2++)
- {
- $row2=mysql_fetch_array($result2);
- $zones=array();
- $zones[0]=$row1[1];
- $zones[1]=$row2[1];
- sort($zones);
- if($zones[0] == 999 || $zones[1] == 999)
- {
- echo "<td> </td>";
- }
- else
- {
- $query3="SELECT breg FROM newnewjay WHERE fromzone='".$zones[0]."' AND tozone='".$zones[1]."'";
- $result3=mysql_query($query3, $db_conn);
- $c3=mysql_num_rows($result3);
- $row3=mysql_fetch_array($result3);
- print_r($row1);
- echo "<br>";
- echo "<td>z1=".$row1[1].",z2=".$zones[1].",p=".$row3[0]."</td>";
- }
- }
- echo "</tr>";
- }
- echo "</table></body></html>";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement