[thelist] PHP

[Edward McCarroll]

> I am looking to create a PHP script that will allow the following:
> * For new users, create new MySQL tables
> * For existing users, add rows to existing tables
> * For existing users, they can delete, add or modify rows in 
>   existing tables
> 
> Any ideas or hints around the high level methodology/PHP commands
> and/or MySQL queries around achieving this?

I think you are highly unlikely to find an existing solution that takes
the approach you suggest.  I don't know why you want to create a new
table for each user, but it usually isn't done that way.  Typically,
you have one table containing data for all users, with a "User ID" column
identifying the applicable user.

I would suggest that you find two good books, one on the mechanics of
using PHP with MySQL, and one on the basics of sound database design.

HTH,

  Ed

"Every man is guilty of all the good he didn't do." (Voltaire)
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -