im writing a function that will create a new database and all of the tables that I need. the first step i do is create the database, which works. then I select it. after that I try to create the first table and it failes.
If I already have the database created and just have the php function create the tables it works, and I can create more than one table. do i have to do some kind of flush when I create the database?