Table Design Query

[Nixon]

Hey all,

I am currently in the middle of making a guitar classifieds website. The buying system works by the seller setting a minimum offer price and the buyer puts in an offer above the minimum price. The only problem I have is storing the buyers offers. I was thinking that I could hold them in a table and link them to the correct classified with ID's. e.g

offerid | classid | username | offer

 1    |     26    |    jack       |   150

offerid = id of the offer
classid = id of the classified that the offer was offered on 😕
username = buyers username
offer = price offered

Is there a better way to do this like using one field and then using the explode() command using * as the explode symbol or something. Any ideas would be helpful.

Thanks.

Jack

[bastien]

What you got is pretty good. Using one field would require more work to make it all go.

[kevinsequeira]

what you're doing seems fine.

reg
kevin