• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Finding auctions that a member has won problem

 
John Turner
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I am developing an online auction website and I am having difficulty if thinking about how I would allow a member to view auction items they have won.

Currently I have two MySQL tables called items and bids where items contains the details of items and bids contain details of bids for items in the items table.

I have thought about comparing the bidder's highest bid with the end date and whether the reserve price has been met, then forwarding this information to my JSP page to display items that have been won, but I don't think this is possible because a bidder's highest bid may not be the highest bid within the auction.

Any suggestions would be welcome.
 
Madhan Sundararajan Devaki
Ranch Hand
Posts: 312
Java MS IE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please list the table structure of both the tables.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic