Philip Thompson wrote:
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 " .
[snip]
$_SESSION["director"][$i] = $row["people_1.first_name"] . " " . $row["people_1.last_name"];

Do you really need to select _every_ column from _all_ of those tables? To solve your problem, you need to select the columns with aliases...


$query = "SELECT people_1.first_name as p1_first_name, people.first_name as p_first_name, ...";

Now you'll have $row['p1_first_name'] and $row['p_first_name'] available.

--

---John Holmes...

Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

php|architect: The Magazine for PHP Professionals – www.phparch.com

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to