[Resolved] Simple Select Statement

collegefan

I can't seem to get the following select statement to work.

$GetData = mysql_query ("select
year,
SUM(wlt='W') AS win

      from games

      where team1 = '$team' and win > '9'

      group by year

      order by win DESC");

I think the problem has to do in the where statement with the (and win > '9') when I try to limit the listing to 10 wins or more. The select statement is not working with the addition of the 'W' in the games database.

Does anyone know what I am doing wrong?

David

LordShryku

What's this supposed to be?

SUM(wlt='W')

collegefan

Sorry,

I have a football games database where one of the columns of data is either a W for Win, L for Loss, or T for Tie and is called wlt. I do this because of forfeits where a larger score may not mean a win.

What I am doing with the SUM(wlt = 'W') is adding up the wins in a season by grouping them by year.

The select statement works just fine when I remove the (and win > '9') statement. The problem is it gives me all the years of football a team has played where I am trying to limit the listing to 10 Wins or more.

David

LordShryku

Right, right, I see now. Though, it seems a little weird to do it that way. Anyway, what you need is a HAVING statement. Look it up to see how it's executed....

collegefan

Thanks,

Works like a charm now. Didn't know about the HAVING Statement - probably still don't but knowing what direction to look was all I needed.

David