CREATE TABLE ** SQL statement

[34534534534555]

Hello,

I am trying to 'dynamically' create tables for each race in an event. Every time i press the 'new race' button, i want to run the query but have the table name ie, Race1 incremented? Any ideas would be much appreciated.

TIA

Please let us know what you think of posts, feedback is always appreciated as this will help to further our knowledge as well.
---------------------------------------------------------------------------
All that's required for evil to suceed is for good men to do nothing.

 

[swampBoogie]

It's not a good idea. I don't see why you can have one table with the event name as part of the primary key.