Hi all.
I am having a problem obtaining the specific information I need. I have a table of "people" that can have multiple rows - ie, Director, Manager, etc. However, in the "projects" table, each project has a director AND manager, but not necessarily the same person.
I have the query to pull the information - and I know it works for everything else. Now how do I reference the director/manager to store it in a variable without having to use numerical indexing?
--------------------
$query = "select projects.*, locations.*, funding.*, people.* from people as people_1 RIGHT JOIN " .
"(people RIGHT JOIN (funding RIGHT JOIN (locations RIGHT JOIN projects on locations.id = " .
"projects.location_id) on funding.id = projects.funding_id) on people.id = projects.manager_id) on " .
"people_1.id = projects.director_id $whereCondition order by $criteria";
$result = @mysql_query($query, $link);
$i = 0;
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
// there are much more fields, but I have only included the
// two important ones (manager and director)
$_SESSION["manager"][$i] = $row["first_name"] . " " . $row["last_name"];
$_SESSION["director"][$i] = $row["people_1.first_name"] . " " . $row["people_1.last_name"];
$i++; } --------------------
It does not work whenever I include the table within the $row[]. Otherwise, it shouldn't be a problem. Any suggestions?
Thanks in advance, ~Philip
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
