[phplib] OT: Joining Tables From: HurricaneIndy <email protected>
Date: 05/14/01

Hey all,
I want to create an admin page which shows a listing of all the users in the database. Problem is most of the columns in my users table are foreign keys going to another table. So the way my users table is setup right now, I can only get: userid,username and password. If I join another table in the query I can get what company they belong to. But there are about 5 more columnns I would like to get. How would I go about getting the rest and outputting it? I know that I can just create another query.. $result, $result2 and so on...but there must be a better way correct?

Indy

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>