mysql insert select

[Anon]

i want to select values from many databases, everyone with the same structure, into another temporary table.

so the query goes:

insert into temp (val1,val2,val3) select val1,val2,val3 from $tbl_name where something='something';

and i loop the query with different $tbl_names.

the thing i want is that i could get the loopig $tbl_name in the temp table too.
nut how?

is it understandable?
anyone bothers to help?

[[deleted]]

"is it understandable?"

not really.
You want to select data from many tables into one temporary table, but what do you mean by "the thing i want is that i could get the loopig $tbl_name in the temp table too"