[RESOLVED] Dynamic Array help

[daveyc]

Hi there,

I'm having a little trouble with using arrays :rolleyes:

Basically, I need to structure the array like the following but from a database.

$list = array(
'Node 1' => 'node1.thisurl.com',
'Node 2' => 'node2.thisurl.com'
);

The database I have is set out like this:

id | server | location | url | ftp | smtp | http | pop | mysql

I've got the data in the table already, but all i need to do now is generate the array.

I've tried this

$sql = "SELECT `server`, `url` FROM `table`";
$result = mysql_query($sql);

while ($row = mysql_fetch_array($result)){ 

      $list = array(
      $row['server'] => $row['url'],
      );
} 

But it doesnt seem to be working.. I've probably missed something really stupid, but hey, i'm a noob..

Any help would be REALLY appreciated 🙂

Dave

[laserlight]

It would be something like this:

$sql = "SELECT `server`, `url` FROM `table`";
$result = mysql_query($sql);

$list = array();
while ($row = mysql_fetch_assoc($result)) {
    $list[$row['server']] = $row['url'];
}

[daveyc]

laserlight wrote:

It would be something like this:

$sql = "SELECT `server`, `url` FROM `table`";
$result = mysql_query($sql);

$list = array();
while ($row = mysql_fetch_assoc($result)) {
    $list[$row['server']] = $row['url'];
}

Thanks laserlight 🙂 It's starting to come together now, but it's still not working 100% 🙁

Maybe posting the rest of the code would help diagnose my issue better! lol

$services2 = array(
'ftp' => 21,
//'SSH' => 22,
'smtp' => 25,
'http' => 80,
'pop' => 110,
'mysql' => 3306
);


$sql = "SELECT `server`, `url` FROM `table`";
$result = mysql_query($sql);

$list = array();
while ($row = mysql_fetch_assoc($result)) {
    $list[$row['server']] = $row['url'];
} 

foreach($list as $svrName  => $host){
						foreach($services2 as $svcName => $port)
						{
						$status2 = "OK";
								if(!($f = @fsockopen($host, $port, $errno, $errstr, 10)))
									$status2 = "ERROR";
							else fclose($f);
							$sql = "UPDATE `table` SET `$svcName` = '$status2' WHERE `server` = '$svrName' LIMIT 1;";
							$result = mysql_query($sql) or die(mysql_error());
						}
					}

I stuck a print_r(); before the while loop to see what the array was generating, and only the URL information was coming out, no server name 🙁

Any ideas?

Dave

[daveyc]

Anyone have any ideas please?

Thanks