$result = mysql_query('SELECT subject, lft, rgt, id, contact_1_id FROM subject WHERE lft BETWEEN ' . $row['lft'] . ' AND ' . $row['rgt'] . ' ORDER BY lft ASC;');

if(!$result) {

die("Ouch! My select statement didn't work. Ouch! -> " . mysql_error());

}

<?php
/* DO NOT EDIT THIS AREA */
include('../include/includes_global/db_connect.php');
$r_width="5%";
$page_title = "Research: By subject";
include('../include/includes_global/breadcrumb.php');
include('../include/includes_global/header.php');
include('../include/includes_local/left_nav_research.php');
?>
<div class="content_header"><?php echo $page_title;?></div>
<!-- Main Content Here -->

<p>
Below is a list of subjects with online databases available for your research. For <strong>online reference sources</strong> on topics ranging from art to science, visit our <a href="research/reference_sources.php">reference sources</a> page. The Library also has a large collection of print reference sources; for help in selecting these, ask for help at the <a href="about_the_library/departments/reference.php">Information & Reference Desk</a>.<br>

<br>
<p>This is the test area</p>


<p></p>
<p></p>
<br>
<br>
<br>
<br>
<?php
include('../include/includes_local/note_database_access.php');

function display_tree($root) {
// retrieve the left and right value of the $root node
$result = mysql_query('SELECT subject, lft, rgt, id, contact_1_id FROM subject WHERE subject="'.$root.'";');
$row = mysql_fetch_array($result);

// start with an empty $right stack
$right = array();

// now, retrieve all descendants of the $root node
$result = mysql_query('SELECT subject, lft, rgt, id, contact_1_id FROM subject WHERE lft BETWEEN ' . $row['lft'] . ' AND ' . $row['rgt'] . ' ORDER BY lft ASC;');


if(!$result) {
die("Ouch! My select statement didn't work. Ouch! -> " . mysql_error());


// display each row
while ($row = mysql_fetch_array($result)) {
// only check stack if there is one
if (count($right)>0) {
// check if we should remove a node from the stack
while ($right[count($right)-1]<$row['rgt']) {
array_pop($right);
}
}

if (strlen($row['contact_1_id'] > 0))
{
// display indented node title

//if it's Business, link directly to the Business site
if ($row['id'] == "50")
{
echo str_repeat('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;',count($right))."<a href=\"http://www.freeman.tulane.edu/turchin\">" .$row['subject']."</a><br>";
}
else if ($row['id'] !== "50")
//if it's Latin American Studies, link directly to the Latin American Library
if ($row['id'] == "51")
{
echo str_repeat('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;',count($right))."<a href=\"http://lal.tulane.edu\">" .$row['subject']."</a><br>";
}
else if ($row['id'] !== "51")
{
echo str_repeat('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;',count($right))."<a href=\"research/subject_detail.php?id=" . $row['id'] . "\" title=\"" . $row['subject'] . "\">";
if (strlen($row['subject']) > 23)
{
echo substr($row['subject'],0,23) . "...</a><br>";
}
else
{
echo $row['subject'] . "</a><br>";
}

}
}
else
{
echo str_repeat('&nbsp;&nbsp;&nbsp;',count($right)) . "<strong>" . $row['subject']."</strong><br>";
}

// add this node to the stack
$right[] = $row['rgt'];
}
}


?>

<br>
<table cellpadding="4" cellspacing="1" border="0" width="100%">
<tr>
<td valign="top" rowspan="2" class="content_table_white" width="33%">
<?php
display_tree('Arts & Humanities');
?>
</td>
<td valign="top" rowspan="2" class="content_table_white" width="33%">
<?php
display_tree('Sciences & Engineering');
?>
</td>
<td valign="top" class="content_table_white" width="33%">
<?php
display_tree('Social Sciences');
?>
</td>
</tr>
<tr>
<td valign="top" class="content_table_white" width="33%">
<?php
display_tree('Interdisciplinary Studies');
?>
</td>
</tr>
</table>

</p>
<a href="<?php echo $_SERVER['REQUEST_URI'];?>#top"><img src="/images/return_to_top.gif" alt="Return to top of page" width="39" height="50" border="0" align="right"></a>
<!-- End Main Content -->
<?
/* DO NOT EDIT THIS AREA */
include('../include/includes_local/right_nav_blank.php');
include('../include/includes_global/footer.php');
?>