Dark-Elk Posted October 22, 2003 Share Posted October 22, 2003 I\'m trying to create a table on a MySQL database using PHP. I think I have my query right (don\'t have it on me at the moment), but it has CREATE TABLE $table I want it to CREATE TABLE with the table being called whatever $table is currently at...for instance if I was doing a while loop with a counter, create a table named 1, 2, 3, 4, etc. Does SQL allow you to create a table while using a variable? Could someone help? I\'m more than a little confused. Fight on, Dark-Elk Quote Link to comment Share on other sites More sharing options...
sir nitr0z Posted October 22, 2003 Share Posted October 22, 2003 understand problem, not, do i... can you create empty tables? Quote Link to comment Share on other sites More sharing options...
Dark-Elk Posted October 22, 2003 Author Share Posted October 22, 2003 I can create tables and all kinds of happy stuff. But it won\'t let me create tables where the table name is a variable...for instance, $table. Instead, it creates a table called \"$table\". Do CREATE TABLE statements in PHP not allow variables to be used? Fight on, Dark-Elk Quote Link to comment Share on other sites More sharing options...
effigy Posted October 23, 2003 Share Posted October 23, 2003 yes, variables can be parsed within double quoted strings... we may need to see your code to help further. also, are you sure the variable is being set? i.e., not a register_globals issue. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.