Newbie needs help with MySQL and PHP

[KoKopuffz]

What I am trying to do is make a registration form with address info .. username and password. And once registed an account is setup. When logged into your account be able to attach multiple work orders to that unique user ID. I was thinking of having 3 tables .. One for registration info .. One for Work Order info and one that holds provinces and states. Any tutorials that will help get through this type of relational setup? Or any help would be appreciated.

[bastien]

three tables yes, but leave the provinces/states out (use an array to store them, simpler and easier and quicker with no db call for that info)

users_table
user_id
user_fname
user_lname
etc

orders_table
order_id
order_item
order_quantity
etc

user_orders_table
user_id
order_id

[n00854180t]

Try http://www.webmonkey.com
Goto Programming > PHP and then click the PHP MySQL tutotial.