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

Reply via email to