• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Tim Cooke
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
  • Rob Spoor
  • Junilu Lacar
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
  • Carey Brown
Bartenders:

Finding auctions that a member has won problem

 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 312
MS IE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Please list the table structure of both the tables.
reply
    Bookmark Topic Watch Topic
  • New Topic