Supplied argument is not a valid MySQL r

[Anon]

I am not sure why I am gettng this error:
"Supplied argument is not a valid MySQL result resource "

I m trying to get an output liek this:
Group
Service
machine 1
Machine 2
*Other info

Here's the code. Any hint?

thanks

<?php
$usr="usr";
$pwd="pwd";
$db="servinv";
$conn = mysql_connect("localhost", "$usr", "$pwd");

?>

<?php

function getAssocArray($sql) {
$res = mysql_query($sql);
$arr = array();
while ($row = mysql_fetch_array($res)){
$arr[$row["ind"]][] = $row["val"];
}
return $arr;

}

$svr = getAssocArray("SELECT group_name AS ind, machine_name AS val FROM servinv");

$svc = getAssocArray("SELECT group_name AS ind, service_cat AS val FROM
servinv");

$keys = array_merge(array_keys($svc), array_keys($svr));

echo "\n<ul>";
foreach($keys as $ind) {
// group name
echo "\n\t$ind";

// list services
echo "\n\t\t<div class='service'>\n\t\t\t".implode(" | ",$svc[$ind])."\n\t\t</div>";

// list servers
echo "\n\t\t".implode(" | ",

$svr[$ind])."\n\t\t</div>";

echo "\n\t</li>";

}
echo "\n</ul>";

?>

[lawnmowerman]

Use "print mysql_error();" heavily in your code. In each call to mysql_query(), you should print/mail/log mysql_error() if an error is returned.

-Rich

[Anon]

I fixed this problem, but now another issue.

I am getting the output liek this

Group
Sevice1
Service2
Machine1
Machine2

I want it like this
Group
Service1
Machine1
Service2
Machine2
And its duplicating the output too.

<?php
$usr="usr";
$pwd="pwd";
$db="database";
$host="localhost";
$conn = mysql_connect("$host", "$usr", "$pwd");

?>

<?php

function getAssocArray($query,$db) {
$res = mysql_db_query($db,$query);
$arr = array();
while ($row = mysql_fetch_array($res)){
$arr[$row["ind"]][] = $row["val"];
}

return $arr;
}

$svr = getAssocArray("SELECT services.group_name AS ind,
service_index.machine_name AS val FROM
services,service_index where
services.service_cat=service_index.service_cat",$db);

$svc = getAssocArray("SELECT services.group_name AS
ind,services.service_cat as val FROM
services",$db);

$keys = array_merge(array_keys($svr), array_keys($svc));

echo "<ul>";
foreach($keys as $ind) {
// group name
echo "<h3>\n\t<br>$ind</b><br></h3>";

// list services

echo "<li>\t<div class='service'>\n\t\t\t".implode(" <br>",$svc[$ind])."\n\t\t</div>";

//echo "<br>$svc[$val]";

// list servers

echo "\n\t\t<div class='machine'>".implode("<br>",$svr[$ind])."\n\t\t</div>";
//echo "<br>$svr[$ind]";
echo "</li>";
}
echo "</ul>";

?>

[lawnmowerman]

I think the problem is that you are merging the two arrays into a single array.

Remove the array_merge() line and use a nest foreach() call to list the servers that have each service.

-Rich