How to create and add a loop in existing table

Question

for example i already have an existing table name (Bronze) what i want is to create an another table called Bronze1,Bronze2,Bronze3,Bronze4, and so on . . in the table name

this is the sample of my code please help

for($i = 1; $i<99 ; $i++) {

   $this_table = 'Bronze'.$i;

   $create =mysql_query("Create Table $this_table")
}

i don't know how to put the right code in the loop there to create the table bronze1,bronze2,bronze3, and so on. so hard to explain >.< can give me an example that might work sir? — John Ernest Seraspi
– John Ernest Seraspi, Commented Jul 9, 2015 at 10:28
You want to make 2 tabels in 1 loop?, Just store the tables in a variable and ouput them after the loop. — PHPhil
– PHPhil, Commented Jul 9, 2015 at 10:28
i want to create it 1by1 for example bronze1 already created ,then the nxt time i refresh the php bronze2 will be created then bronze3,then bronze4 . .. — John Ernest Seraspi
– John Ernest Seraspi, Commented Jul 9, 2015 at 10:36

DocRattie · Accepted Answer · 2015-07-09 10:44:34Z

1

Try this SQL-statement:

CREATE TABLE new_tbl LIKE orig_tbl;

in your case:

for($i = 1; $i<99 ; $i++) {
   $this_table = 'Bronze'.$i;
   $create =mysql_query("Create Table $this_table LIKE Bronze")
}

that will create a table based on another one.

answered Jul 9, 2015 at 10:44

DocRattie

1,4232 gold badges14 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create and add a loop in existing table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related