[PHP-DB] Test

2005-03-21 Thread Juffermans, Jos
Sorry to use this, but I don't know if my messages are arriving... Can someone (only 1 please) reply that my message was received? Jos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Test

2005-03-21 Thread Joseph Crawford
recieved On Mon, 21 Mar 2005 12:50:46 +0100, Juffermans, Jos [EMAIL PROTECTED] wrote: Sorry to use this, but I don't know if my messages are arriving... Can someone (only 1 please) reply that my message was received? Jos -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Working with multiple tables...

2005-03-21 Thread NIPP, SCOTT V \(SBCSI\)
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

Re: [PHP-DB] Working with multiple tables...

2005-03-21 Thread Micah Stevens
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

RE: [PHP-DB] Working with multiple tables...

2005-03-21 Thread NIPP, SCOTT V \(SBCSI\)
Within the same server, even the same database, just a different table. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -Original Message- From: Micah Stevens [mailto:[EMAIL PROTECTED] Sent: Monday, March 21, 2005 1:47 PM To:

Re: [PHP-DB] Working with multiple tables...

2005-03-21 Thread Forest Liu
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

Re: [PHP-DB] Working with multiple tables...

2005-03-21 Thread Mark Cain
What is the nature of the userid? is it something assigned by one of the systems? or is it chosen by the user himself? or is it a constant such as am employee ID? Here's how I would approach it: query the tables for the occurrence of the userid and obtain the system name at the same time.

Re: [PHP-DB] Working with multiple tables...

2005-03-21 Thread Bastien Koert
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