QUERY TO SHOW LOWEST BID

[gsc123]

Hi

Need a query to show lowest bid for that user,

ie:

user1 has bid 250
user2 has bid 320 as a proxy

so when user1 logs in he only sees next bid as 260 an then if he bids i can use a query to notify that the bid is not high enuf .. any help is welcome

 

[HarleyQuinn]

Having no idea how your tables are set up we're kind of working in the dark here, but a quick example using one table could be:

Select Username, Min(bid) as MinBid
From YourTable
Where Username = "user1"
Group By Username

Hope this helps

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com

 

[gsc123]

So the bid is the bidAmount in my table?

so thats

select min(bidAmount) as minBid from customers where idcustomer = 15

-- because I'm only after the min bid for my bidding even though theres a higher bid, this should still work?

 

[HarleyQuinn]

That should work fine, did you try it out and see if it worked correctly for you?

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com

 

[gsc123]

Well my biggest problem is this

I use this wuery to get most of the information, the price is updated in two tables, one bidhistory and the other the product on offer as the final price so I need somewhere in this select query to pull out min bid for users below the proxy bid...

ie

SELECT products.Description, products.Price, products.ImageUrl, products.idproduct, products.endDate, suppliers.idsupplier, suppliers.supplierName FROM suppliers INNER JOIN products ON suppliers.idsupplier = products.idsupplier WHERE idcategory=21 and ListHidden =
false


EG:
products.Price SHOULD BE

(select min(bidAmount) from bidhistory INNER JOIN products ON products.idproduct = bidhistory.idproduct) as price

...but it dont work ..

is this my structure, becuase bidhistory is only a history of bids not the products price initially laid out, it start price say £200 ... if theres no bids then the history does'nt have a record so I need the products.price to show min price instead of bidhistory...


I hope this is clear.. many thxs in advance