What is the most efficient way to make a user database in PHP/MySQL.?

I'm making a website and need to allow users to log-in and store information. I only have access to one database, but I can make as many tables and fields as I need.





What sort of structure should I use to store the information? Do I have to use some "index" thing?





I know almost nothing about MYSQL, but I'm good at coding things I don't know. The PHP and the HTML forms is a cinch, I just need to know how to structure the files.





Thanks!

What is the most efficient way to make a user database in PHP/MySQL.?
Before you do anything you need to read a book on PHP sessions or cookies. After you do this you will know how to structure a database for multiple user accounts.





The idea is that you know who your visitor is by its unique session id and you make sure to inculde this in you WHERE clauses whenever you make a query to the database.





Good luck.
Reply:I know of a tool that i hope you'll make use of:





Easy PHP


http://www.easyphp.org
Reply:Try using PHPMyAdmin (http://phpmyadmin.net). It is a web-based editing script for MySQL databases, written in PHP. It'll allow you to visually setup your database.