insert in to $variable valuse

[student1]

$variable= 123;

$query = "INSERT INTO $variable VALUES ('$TYPE','$TASK');

will this work?? please tell..
i have to use a value stored ina variable in place of the table name.

[billkirim]

$variable= 123;

$query = "INSERT INTO $variable VALUES ('$TYPE','$TASK');

will this work?? please tell..
i have to use a value stored ina variable in place of the table name.

123 is your table name?
Don't forget to close your quotes at the end of the query.

[vssp]

Chck the variable value pass teh insert query


vssp

[Nert]

$variable= 123;

$query = "INSERT INTO $variable VALUES ('$TYPE','$TASK');

will this work?? please tell..
i have to use a value stored ina variable in place of the table name.

hi,

i don't think that will work, you did not specified any table name where that value be inserted..

try to follow this simple query for inserting values on a database table
"INSERT INTO tablename fields VALUES('values')";
and don't forget to close the tags..

bye -- bye

--nert

[ronverdonk]

Excuse me! There is some misconecption about using PHP in constructing sql statements here.

Of course it will work, building a statement like this is perfectly legal:

[php]
$My_table = "Clients";
$column = "clientname";\
$value = "Johnson";
$sql_stmt = "SELECT * FROM $My_table WHERE $column = '$value'";
[/php]
Ronald :cool:

[Nert]

Excuse me! There is some misconecption about using PHP in constructing sql statements here.

Of course it will work, building a statement like this is perfectly legal:

[php]
$My_table = "Clients";
$column = "clientname";\
$value = "Johnson";
$sql_stmt = "SELECT * FROM $My_table WHERE $column = '$value'";
[/php]
Ronald :cool:

upss! I'm sorry (^_^) i did not read student1's post very well cause i'm in a hurry last time, i thought the variable $variable having the value '123' is the value to be inserted in a table.., that's why i said it won't work because student1's did not specify any table. yah of course that will work with php.