join a table and allow edits

[estonham]

I have two tables..

TABLE = user_details

ID(autoincrement)
username
password
address
city
zip
email
newsletter
marketing1
marketing2

TABLE = user_products

username
product_name
product_serial
product_pdate
product_dealer

I can get the registration to add the username to the 2nd table but cannot figure when I need to add product to it for this user when in the session.

also how do I display the two tables and only pull the details for that user, as user could have many records.

This is a free project for a charity website and would be great to get some help.

As I say I have managed to get a login and registration working and session's working but cannot get a join and edit section working and add new product to users list.

Regards
Edd

[justsomeone]

I can get the registration to add the username to the 2nd table but cannot figure when I need to add product to it for this user when in the session.

Um.. we can't figure that out either without understanding what you are trying to do...

I would imagine that you probably don't want to add a record to the second table without having the values for all the fields in it, but then, I have no idea what it is you are trying to do.

also how do I display the two tables and only pull the details for that user, as user could have many records.

The following SQL will list all details from the user_product table for a particular user (in this example, user "john"). How you build it up from your PHP is up to you.

select (*) from user_products where username = "john";

One additional point to note is that you should probably be using the user ID rather than username in the user_products table.