ID: 11548 Updated by: swm Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Bogus Bug Type: MySQL related Operating system: PHP Version: Earlier? Upgrade first! Assigned To: Comments: 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. Previous Comments: --------------------------------------------------------------------------- [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]
