[PHP-DB] Aliased mysql queries and mysql_fetch_array()

2004-10-22 Thread Philip Thompson
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

Re: [PHP-DB] Aliased mysql queries and mysql_fetch_array()

2004-10-22 Thread John Holmes
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.*,