Can't Think Of How to set the database up.

[farel]

Hello, Im trying to make a mock trading application for a youth business class I assist with.

Here is my problem. I do not know how to set up the database design. here is what I got so Far

Member
(Name, Pass, Email)

The second table is what I'm trying to figure how to set up I want there transactions they previously had to display in a way sort of like how paypal displays its transactions. The only dilema I come across when trying to make it is that I think how could I set it up so that the (2) people involved in the trade are recgonized when php queries the database looking for the members involved.

Can you put both that where involved into the same field?

Thats the only way I can think of Thank You in advance.

Perhaps to better explain this If someone understands the logic of how paypal displays its data specific to each member that would help as well.

Thank You

[pjleonhardt]

You could have your 2nd table look like the following

| TransactionID | User1 | User2 | Amount | Time | etc...

where User1 is the one who transferred the funds and user2 receiving, or viceversa..

[drawmack]

or you could use proper normalization on the database

  users
    id
    name
    <etc>

  transactions
    id
    product
    net_shares
    price_per_share

  users_to_transactions
    id
    tran_id
    user_id
    shares

[farel]

Yes, I had these ideas But im just not sure how I would go about selecting and displaying the information in a html table in which it would select if the user was either user 1 or user 2. Can some one help me with this as well. Thank You.

[drawmack]

post your database structure and we'll help with the queries.