Finding auctions that a member has won problem

[John Turner]

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]

Please list the table structure of both the tables.