Jump to content


Photo

Is this possible?


  • Please log in to reply
4 replies to this topic

#1 Eugene

Eugene
  • Members
  • PipPipPip
  • Advanced Member
  • 126 posts

Posted 11 April 2006 - 11:08 PM

Creating a main table, and then a table inside the main table.

#2 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 11 April 2006 - 11:11 PM

No. Why? Maybe I don't even understand the question. Perhaps enum fields are what you want. Maybe we need more detail about specifically what you are trying to accomplish?
Legend has it that reading the manual never killed anyone.
My site

#3 Eugene

Eugene
  • Members
  • PipPipPip
  • Advanced Member
  • 126 posts

Posted 11 April 2006 - 11:28 PM

Ok, someone registers and a table is created in their name.

They have now access to a panel which they can insert information etc...

Can that information be inserted into a table inside their name?

#4 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 11 April 2006 - 11:41 PM

It's a really bad idea to create new tables as a result of user actions. You should carefully rethink your design.

What does your site do, what kind of information are users able to store?

#5 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 12 April 2006 - 03:35 AM

Or, you could just make a normal table, add whatever it is you're INSERTing, and tack on a user_uid FK and only show them their records; views in 5.0 make these even easier, because then you actually can "create" a view by username! Why make this unnecessarily complicated? And yes, wickning1 is right -- never dynamically create databases/tables/columns.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users