Passing variables to a query...

[vous]

Hello All,

NOTE:I'm using php 4.2.2

I'm trying to write a script that will enable me to create tables using an assigned variable as a tablename. So far I have not been able to append the variable to the "table name" in the create sql command...

This is what I have tried so far:

function create_test_table($id, $frm) {

global $CFG, $ME;

$qid = db_query(" CREATE table sp_test_'$frm[test_name]' ( id int not null auto_increment primary key, test_name varchar(25), descr varchar(50), text_field1 varchar(50), text_field2 varchar(50), answer varchar(20))");

}

I'm kinda-new to php4 and would greatly appreciate any helpful comments...

thanks,

vous.

[rheroux]

You need to use either single quotes or double quotes around the array field in your query. Try this:

function create_test_table($id, $frm) { 

global $CFG, $ME; 

$qid = db_query("CREATE table sp_test_'".$frm['test_name']."' ( id int not null auto_increment primary key, test_name varchar(25), descr varchar(50), text_field1 varchar(50), text_field2 varchar(50), answer varchar(20))"); 


}

[vous]

Hey thanks man! It worked!