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 <oxware@xxxxxxxxx>
Reply-To: Forest Liu <oxware@xxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: Re: 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)
<sn4265@xxxxxxx> 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@xxxxxxx
> 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
