AnotherPoetsCry Posted January 18, 2007 Share Posted January 18, 2007 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! Quote Link to comment https://forums.phpfreaks.com/topic/34653-ajax-with-mysql-in-php-display-for-buyers-and-sellers/ Share on other sites More sharing options...
bibby Posted January 21, 2007 Share Posted January 21, 2007 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 buyersuserID | Role | email..|ect..#table things, allows sellers to sell many thingsthingID| sellerID | pricePerThing | numberOfThings#table transactionstransID | sellerID | buyerID | thingID | agreedPricePerThing | negotiatedNumberOfThings[/code]Dig ? Quote Link to comment https://forums.phpfreaks.com/topic/34653-ajax-with-mysql-in-php-display-for-buyers-and-sellers/#findComment-165877 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.