Forums
This topic is locked
dynamically calling multiple tables for admin
Posted 08 Nov 2006 08:02:02
1
has voted
08 Nov 2006 08:02:02 bryan gray posted:
ok forgive me if my question is a bit convoluted. I am using php 4.4.4 and mysql 4.01. To start off with I want a user to register. the results will go into table users. now after the user registers I would like another table to be created dynamically and the table name would then be inserted into table users to correspond to whatever user just registered. I am assuming I can just write a sql statement with the variable name to create the new table. After this is accomplished I need to display that table every time a user logs in. I also need the user to be able to edit, delete and add new records to this table from this page. So what is the best way to call up this table when the user logs in? Should I use a session variable? I have no problem creating pages that edit, delete and add records to a database if there is only one main table. I need a dynamic admin page. is there some master variable that I can pass to edit delete and add records to the db? there are many more things that I am trying to do here but this is my main prob. I can create a reg page, login page, table listing page, edit page, and add record page if there is only one main table to display. I am just unsure how to do this with multiple tables. Thanks for the help