| Scott V Nipp 2005-03-21, 8:55 pm |
| Within the same server, even the same database, just a different
table.
Scott Nipp
Phone: (214) 858-1289
E-mail: sn4265@sbc.com
Web: http:\\ldsa.sbcld.sbc.com
-----Original Message-----
From: Micah Stevens [mailto:micah@raincross-tech.com]=20
Sent: Monday, March 21, 2005 1:47 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Working with multiple tables...
Seperate on another MySQL server, or seperate within the same MySQL
server?
On Monday 21 March 2005 11:44 am, NIPP, SCOTT V (SBCSI) 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
--=20
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
|