Fw: mysql multiple query

> hello.. > i have a pretty wired query to do with php/mysql . > i don't manage to do > > mysql_query($qry,$connection); . > (query bellow) > > so i found a quick and dirty solution.see bellow . > but it's no realy elegant . > > any ideea how can i do multiple queries at once with mysql_query() ? > > function copy_question($qid,$test_target) { > global $connection,$username,$password,$database; > > > $fp = fopen ('/tmp/copy_table_qry', 'w'); > > $qry="create temporary table q_temp as select * from questions; > create temporary table ans_temp as select * from answers; > set @test_id=$test_target; > set @q_id=$qid; > insert into questions select > '',@test_id,t2.q_type,t2.description,t2.dimension,t2.combination,t2.checkit > from q_temp as t2 where id=@q_id; > select @last:=LAST_INSERT_ID(); > insert into answers select '',@last,score,description from ans_temp where > id_question_fk=@q_id;"; > > fputs($fp,"$qry"); > fclose($fp); > > $a=exec("/usr/bin/mysql -u $username -p$password $database > </tmp/copy_table_qry"); > -- > > thnx . >