[php]
} elseif ($_GET[ViewPlans]) {
$View_Plan_Query = mysql_query("SELECT hosts_name.name,hosts_info.id,hosts_info.name FROM hosts_name,hosts_info WHERE hosts_name.id = hosts_info.host_id");
$Host_Array = mysql_fetch_array($View_Plan_Query);
echo "$Host_Array[0]";
while ($row = mysql_fetch_array($View_Plan_Query)) {
echo "<TR><TD colspan="3"><A HREF="$PHP_SELF?EditPlan=$row[id]">$row[name]</A></TD></TR>";
}
} else {
[/php]
Alright. I had this working. I changed something and to the point that I’m not sure what it was, but it is not erroring, and the array is populated. Pretty much this is drawing from two tables, and i can’t figure out why it wont display the buttom proportion, only the top. It has to be something simple. Not sure. Any help would be appreciated, and if their is a better way of doing this let me know. The hole goal was to bring out the information in 1 query, but at the same time make it so the info drawn from the hosts_name.name was not looped, only displayed once, while the rest of the data is looped.
Thanks for the help and suggestions!
Drew