<?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')
	");

	}
}

?>