create table like new table individually numbered

I'm new to all of this but decided to create an online system for our company but now stuck!

What I'm trying to do is copy a mysql table but each table 开发者_Python百科have a unique number when ever the script is ran i.e. autoquoteS1, autoquoteS2 etc.

I've searched a lot for this and this is the best I can find.

mysql_select_db("sdbdb", $con);
$sql = "CREATE TABLE IF NOT EXISTS autoquoteS1 LIKE autoquoteS";

Any help is very much appreciated

this sounds like a problem.

you should not be creating many many copies of the same table, instead, you should be entering many many rows into a single table. (assuming the same structure)

maybe you can post your table design, and we can help you with normalization.

edit:

you may be looking for something like this:

quote
--------
quote_id
customer_id
total
status

quote_line_item
----------------
quote_id
line_num
quantity
amount
item_id

item
--------
item_id
description