hi there! i'm wondering about these sub-selects and the mysql-version peroblems they cause!
somewhere on mysql.com is said: sub-selects need mysql version 4.1 and up! BUT: i have a statement insert into foo select bar from bartable; this thing works if i enter it on the mysql-shell. (also with some join and where parts added) but if i query my mysql db with that statement from a php file i get DB::ERROR : unknown error ! nobody helped my at the php/pear list so i'm placing it here! my mysql version is 11.15 dist 3.23.41 has anybody an idea,whether i have to upgrade my server,or the php module the server works with? best regards and thanks in advance udo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]