Re: Working with multiple tables...

seems that you should redesign your DB table field structure...to let your query easier. On Mon, 21 Mar 2005 13:44:54 -0600, NIPP, SCOTT V (SBCSI) <sn4265@sbc.com> wrote: > I am working on revising a web request app that I have already > developed. The app basically provides a list of system names with > checkboxes for a user to select to request accounts on the systems. One > feature I am intending to add is that the app should check a separate > database of user accounts to see if the user already has an account on > the system. I think I could get it to work by making a query of the > userid for each system, but this seems quite inefficient. I would > rather somehow have a single query that gets a list of system names and > also checks the user account database at the same time to determine if > the user already has an account. Then I would like to display ALL of > the systems, but "grey out" the ones that the user already has accounts > on. Can someone help me figure out the best way to go about this? > Thanks in advance. > > Scott Nipp > Phone: (214) 858-1289 > E-mail: sn4265@sbc.com > Web: http:\\ldsa.sbcld.sbc.com > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Sincerely, Forest Liu(刘云赟)