Ajax with MySQL in PHP: display for Buyers and Sellers.

[AnotherPoetsCry]

I have a database that holds several 'users' each assigned a role as either a 'seller' or 'buyer'. Every seller must determine a 'pricePerObject'. I need a way collect the price from the sellers and to display that information to a 'buyer' and then allow this buyer to say how many objects he wishes to purchase from which sellers. at the end i must then be able to access all this information so I'm assuming I need to set up a Database to  hold all this info.

| User | Role | PricePerObject | NumberOfObjects |

Without knowing the number of users, how do I set up this program to collect all the users information and then display that to the buyer to collect his info and then do calculations? I'm pretty sure I'll need to use some form of ajax... but I'm not sure how or where?

Thank you!

[bibby]

I'm hoping that you are using more than one table for that.
I'm seeing 3 [i]objects[/i] here,  users, things, and transactions.

[code]
#table users  ,  allows sellers to also be buyers
userID |  Role  |  email..|ect..

#table things, allows sellers to sell many things
thingID| sellerID | pricePerThing  | numberOfThings

#table transactions
transID  | sellerID | buyerID | thingID | agreedPricePerThing | negotiatedNumberOfThings
[/code]

Dig ?