[PHP-DB] Combination of SQL statements invalid in MySQL? From: Andy (news.letters <email protected>)
Date: 11/22/01

Hi there,

I am trying to do a combination of SQL statements like described in a SQL
bóok. Is it possible, that mysql does not allow this syntax?

Thanx Andy

Error:

Occured during executing DELETE FROM test_user_interests WHERE user_id =
(SELECT user_id FROM test_user WHERE user_name = 'herbert01') statement

Error: 1064 You have an error in your SQL syntax near 'SELECT user_id FROM
test_user WHERE user_name = 'herbert01') ' at line 3 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>