ID: 11548
Updated by: derick
Reported By: [EMAIL PROTECTED]
Status: Bogus
Bug Type: MySQL related
Operating system:
PHP Version: Earlier? Upgrade first!
Assigned To:
Comments:
Not a bug. This is a known limitation of MySQL.
Previous Comments:
---------------------------------------------------------------------------
[2001-06-19 07:08:37] [EMAIL PROTECTED]
This is not a users forum. Please address such queries to
SQL/MySQL/php user lists or forums.
Also, please read http://www.php.net/bugs-dos-and-donts.php
before posting.
---------------------------------------------------------------------------
[2001-06-18 23:58:58] [EMAIL PROTECTED]
dear sir
i want to know if the followign scenario has some work around possible
i have a table to project_users and a table of users.
when some one joins my organization i add him in the user table adn then when he
becomes a part of a project he is added to the project users table
to add him to a project he should not already be a part of that project
so i want to execute a query of the form
select user_id from users where user_id NOT IN ( select user_id from project_users
where project_id = $selected_project)
but as you know mysql doesn't support sub-select .]
so is there a workatround using php to handle this sub select pls reply soon
thanx
--akhil
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=11548&edit=2
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
