help with select from statement - auction site

[adammc]

Hi Everyone,

I am in the process of designing a bidding style (auction) website in php / mysql and I have come to a bit of a hurdle with my limited php knowledge.

Table 1 = user details of person posting item
Table 2 = user details of person planning on bidding

I plan to have a third table storing all the current bids on the site with the following rows:

ID of item
Username of bidder
date / time of bid
bid amount

How would I find out the highest bid on the item?

[php]
select from 'bids' WHERE `id`='$id' and bid amount ?
[/php]

[jatar_k]

try using MAX [dev.mysql.com]