Emaze Auction: Lot Winners SELECT lotName, lotType, categoryID FROM Lot WHERE lotID = #lotID# Return to category

#lotID# - #getLotName.lotName#

BuyersWinners

SELECT lotName, lotType, categoryID FROM Lot WHERE lotID = #lotID#

#lotID# - #getLotName.lotName#

 SELECT Member.firstName, Member.lastName, Member.email, Member.organization, Member.phone, Member.username, Member.address, Member.address2, Member.city, Member.state, Member.zipCode, Member.country, Buy.userID, Buy.buyDateTime AS bidDateTime, Buy.buyPrice AS bidPrice, Buy.buyQuantity AS bidQuantityWin FROM Buy INNER JOIN Member ON Buy.userID = Member.userID WHERE Buy.lotID = #lotID# Bid.userID, Bid.bidDateTime, Bid.bidPrice, Bid.bidQuantityWin FROM Bid INNER JOIN Member ON Bid.userID = Member.userID WHERE Bid.lotID = #lotID# AND Bid.bidWin = 1 ORDER BY #order#

There are no winning bids for this lot.

+   - +   - +   - +   - +   -
ID User PriceBid Quantity Total Date/time
Edit #userID#. #lastName#, #firstName# (#username#) #LSCurrencyFormat(bidPrice,"local")# #bidQuantityWin# #LSCurrencyFormat(bidPrice * bidQuantityWin,"local")# #LSDateFormat(bidDateTime, "mm-dd-yyyy")#
#LSTimeFormat(bidDateTime)#
#lastName#, #firstName# (Edit)
Price: #LSCurrencyFormat(bidPrice,"local")#  
Quantity: #bidQuantityWin#
Date/time: #LSDateFormat("#bidDateTime#", "mm-dd-yyyy")# / #LSTimeFormat("#bidDateTime#")#
#email#
#phone#
#organization#
#address#
#address2#
 #city#, #state# #zipCode#
#country#