A left outer join would join those tables together and if you get a result from the users_accounts table, then you could 'grey' out the boxes.

Would need to see your table structure to be able to come up with a query...

Bastien

From: Forest Liu <[EMAIL PROTECTED]>
Reply-To: Forest Liu <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Working with multiple tables...
Date: Tue, 22 Mar 2005 09:15:01 +0800

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) <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > 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(刘云赟)

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


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



Reply via email to