yes, it will not work,because mysql does not support it(the way you try to use is 'procedure' called in MS SQL sever) , mysq developer said they will accomplish in the further . you and I have to wait for it. "VM ÁÖ¿N" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello > > I want to know how to implement these several sql statements in one time. > > For example, I have 2 sql statements like : > > INSERT INTO com VALUES ('pentium'); > INSERT INTO com VALUES ('amd'); > > Then, I want to excute these 2 sql statements in one time with PHP. > > I tried to implement like this : > > $query = " > INSERT INTO com VALUES ('pentium'); > INSERT INTO com VALUES ('amd'); > "; > mysql_query($query, $dbconnect); > > But as you know, it didn't work. > > Does any one know how to run this job? > > _________________________________________________________________ > MSN Explorer°¡ ÀÖÀ¸¸é Hotmail »ç¿ëÀÌ ÈξÀ Æí¸®ÇØ Áý´Ï´Ù. Áö±Ý > http://explorer.msn.co.kr/ ¿¡¼ ¹«·á·Î ´Ù¿î·ÎµåÇϼ¼¿ä. > -- PHP General 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]