Re: Problems finding the MAX value

2005-11-04 Thread SGreen
How it works... "KEVIN ZEMBOWER" <[EMAIL PROTECTED]> wrote on 11/04/2005 12:40:50 PM: > Man, you're awesome. Only two typos in the whole procedure. However, > for the life of me, I'm puzzled over how it works. If you have more > patience can you explain? > > Correct query (table is singular, no

Re: Problems finding the MAX value

2005-11-04 Thread KEVIN ZEMBOWER
Man, you're awesome. Only two typos in the whole procedure. However, for the life of me, I'm puzzled over how it works. If you have more patience can you explain? Correct query (table is singular, not PHPAUCTIONS_...): CREATE TEMPORARY TABLE tmpWinners SELECT auction, max(bid) as winningbid FRO

Re: Problems finding the MAX value

2005-11-04 Thread KEVIN ZEMBOWER
Shawn, thank you for your complete answer. I'm still working through your first post. I apologize for not noticing this FAQ. I didn't take it into account because I thought it only applied to MySQL 5 and I'm using 4.0.24. Thanks, again. I'll be in touch regarding your first post as I work with y

Re: Problems finding the MAX value

2005-11-04 Thread SGreen
[EMAIL PROTECTED] wrote on 11/04/2005 11:22:35 AM: > This is such a FAQ that they put the answer in the manual: > http://dev.mysql.com/doc/refman/5.0/en/index.html > OOPS! I copied the wrong link. It should have been: http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html

Re: Problems finding the MAX value

2005-11-04 Thread SGreen
"KEVIN ZEMBOWER" <[EMAIL PROTECTED]> wrote on 11/04/2005 11:05:05 AM: > My organization runs an online auction on our intranet server for > the United Way. I'm having a hard time printing out a list of the > winning bidders (I'm under a lot of pressure; the baked goods are > getting stale). >