Jump to content


Photo

Creating a table...name = string...


  • Please log in to reply
3 replies to this topic

#1 Dark-Elk

Dark-Elk
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 22 October 2003 - 06:48 PM

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

#2 sir nitr0z

sir nitr0z
  • Members
  • Pip
  • Newbie
  • 5 posts
  • LocationDevon, UK

Posted 22 October 2003 - 08:26 PM

understand problem, not, do i...

can you create empty tables?

#3 Dark-Elk

Dark-Elk
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 22 October 2003 - 10:43 PM

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

#4 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 23 October 2003 - 12:32 AM

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.
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users