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 .
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
