two tables parent-child

[asucrews]

i have two tables, in a parent-child relationship. but it the out not right, i believe i got the query right and i think how settup the array but i am really not sure.

mysql output:
click here

link to site:
click here
php code:

<?php
//connect to database
$link = mysqli_connect('host','user','pass');
mysqli_select_db($link,'aandmsite');

$query = mysqli_query($link,'SELECT colleges.college_id,colleges.college_name, departments.department_id,departments.department_name FROM colleges INNER JOIN departments ON colleges.college_id = departments.college_id' );

while ($row = mysqli_fetch_assoc($query))
{
	$listarray[$row['college_id']] = array( 'college_name' => $row['college_name'] , 'department_name' => $row['department_name']);
}

function generate_list($parent)
{
	$has_childs = false;
	global $listarray;
	foreach($listarray as $key => $value)
	{
		if ($value['college_id'] == $parent) 
		{	
			echo $value['college_name'];
			if ($has_childs === false)
			{
				$has_childs = true;
				echo '<ul>';
			}
			echo '<li>'. $value['department_name'];
			generate_list($key);
			echo '</li>';
		}
	}
	if ($has_childs === true) echo '</ul>';
}

?>
<ul id="categories">
<li>
<?php
generate_list(0);
?>
</li>
</ul>

[planetsim]

Unfortunately none of us here are physicic can you tell us what is not right ?

[asucrews]

i found a way to display the information they way that i want!!! but i geting a extra ul in the output. i try many thing to remove this ul but i can't seem to find the right way to get this extra ul removed. Any Idea on right place to add code to remove this extra ul

This site:
The Site

The html Output:

<ul>
     <li>Agricultural and Environmental Sciences
         <ul>
              <li>Agricultural Leadership, Education and Communication</li>
              <li>Animal and Dairy Science</li>
              <li>Biological and Agricultural Engineering</li>
              <li>Crop and Soil Sciences</li>
              <li>Entomology</li>
              <li>Food Science and Technology</li>
              <li>Horticulture</li>
              <li>Plant Pathology</li>
              <li>Poultry Science</li>
         </ul>
     </li> 
     <ul> <!-- The extra ul -->
     <li>Business
        <ul>
     </li>
</ul>

The Code:

<?php

$query = mysqli_query($link,'SELECT colleges.college_id,colleges.college_name, departments.department_id,departments.department_name FROM colleges INNER JOIN departments ON colleges.college_id = departments.college_id' );
echo "";
while ($row = mysqli_fetch_assoc($query))
{

//Get the current rows id
$current_id = $row['college_id'];

//Did we already see this?
if ($current_id == $old_id)
{
//OK, we are still in the same group, just display child
 echo "<li>" . $row['department_name'] . "</li>";
}
else
{
//New group, display parent record
 if($current_id > 1){ echo "</ul></li>";}
 if($current_id = 1){ echo "<ul>";}
 echo "<li>" . $row['college_name'];
 echo "<ul>";

} 

//Remember id

$old_id = $current_id;

}
echo "</li></ul>";
?>

[foyer]

if($current_id = 1){ echo "<ul>";}

if($current_id == 1){ echo "<ul>";}

.........