Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //locate neighbours
- $connect = mysql_connect("localhost","root","") or die ("Couldn't connect!");
- mysql_select_db("detection") or die ("Couldn't find db");
- $query=mysql_query ("SELECT * FROM nodes");
- while ($row=mysql_fetch_assoc($query))
- {
- $nodid=$row['nodid'];
- $x=$row['x'];
- $y=$row['y'];
- $name="station".$nodid;
- echo $name; echo "<br>";
- $createtable = mysql_query ("
- CREATE TABLE `detection`.`".$name."` (
- `nid` INT( 5 ) NOT NULL ,
- `x` DOUBLE NOT NULL ,
- `y` DOUBLE NOT NULL ,
- `isnb` INT( 1 ) NOT NULL ,
- PRIMARY KEY ( `nid` )
- ) ENGINE = MYISAM ;
- ");
- $query1=mysql_query ("SELECT * FROM nodes WHERE ($nodid>nodid) OR ($nodid<nodid)");
- while ($row1=mysql_fetch_assoc($query1))
- {
- $nodidneigh=$row1['nodid'];
- $xneigh=$row1['x'];
- $yneigh=$row1['y'];
- if ( (abs($x-$xneigh))<60 AND (abs($y-$yneigh))<60)
- {$isneigh=1;}
- else {$isneigh=0;}
- $queryinsertrow = mysql_query ("
- INSERT INTO $name VALUES ('$nodidneigh','$xneigh','$yneigh','$isneigh')
- ");
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement