MYsql database design question

[StevenHickerson]

Hello, I'm completely new to mysql and not very advanced in php. But I'm looking for help on designing a mysql database that is going to be accessed, modified, and all through php files.

What I want is a database with a table of users, and some information about them. And then I also need a way of tracking stuff for each user.

What I'm curious to know is would it be a better design to create a seperate table for each user, or is there a better way to do it that is more efficient? The stuff I need to track for each user really can't go in the same table as the users list.. it would be way to much info for one table I believe. Would really need it as each item a seperate entry for that user.

Thanks for any help you can give and if you have any good links to full php scripts with login, session tracking and mysql interaction let me know please :)

Steven Hickerson

[techgnome]

http://www.xoops.org -- a pre-built system that should be able to handle most of what you need it to.

[StevenHickerson]

Hmm this looks like a good code to look at.. if it isn't to complicated for me to decipher. But I'm trying to construct my own personal one that I can call mine so dont want to just outright use this one :)

Thanks for the link!

[morrowasted]

try this:
http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html

basically you just connect to the database using a PHP function and then send sql queries to the mysql.exe program that edit your database.

it isnt too complicated, really, and after a little bit of dabbling you'll get it.