[RESOLVED] My new project auction site

[ade234uk]

I thought about doing this about 2 months ago. I am looking for another project to do in my spare time, so I thought I would have a crack at creating my own auction site to see how they work. I'm keen but bloody mad.

I have some ideas in place and I have one question. Everything will be linked together via ids across the tables.

A user will login and their member_id will be used as the session. The member_id will be inserted into the bids table, this way I can identify them when they place a bid.

For the moment I need to get my head around one thing with mysql.
Below are two tables very basic tables one for users and the other for bids.

when a user bids the member_id will be inserted into the bids table. Using the member_id I should be able to echo the username from the users table but how do I form a relationship beween the two tables with a mysql statement so that I can do this?

users_table

username
password
member_id

bid_table

auction_id
member_id
bid_amount
date_bid

[tomhath]

Not sure what you want to select, this needs a WHERE clause to pick the member_id or auction_id

select ut.username
from bid_table bt
inner join users_table ut on ut.member_id = bt.member_id

[ade234uk]

Thank you very much for your advice. I give this code a shot later. At least I have the basics to work from. I was never quite sure how you used inner joins.

1) When someone creates a user account, they select a username.
2) When this user bids their member id is inserted in to the bids table.
3) When the bids are displayed from the Auction the username is displayed on the bids, taken from member_id in the users_table

Example

phpbuilder £39.00
ade £36.00
phpbuilder £20.00
ade £10.00

Again thank you for help. Much appreciated.

[ade234uk]

Excellent it works a treat thank you. I can now see how the INNER JOIN works. I can see this being used for other things as well.

What is the difference between an INNER JOIN and LEFT JOIN?