[SOLVED] Help with PHP query

[SocomNegotiator]

Well I have some games that I am querying...here is the code

SELECT id,game FROM ladders ORDER BY game LIMIT 1

 

Now when I say limit 1 it actually limits it to one result. Well I want to limit it to one result for each game. Because I have more than one game, and some games are listed more than once. So I don't need the same game to come up twice. Any ideas what I can put...?

[mrdamien]

SELECT DISTINCT game, id FROM ladders

 

will pick one of each game. You can filter out the results with WHERE conditions.

[SocomNegotiator]

Hmmm....it still returns every game.

 

You got another idea?

[SocomNegotiator]

Hey when I take out id it works. Is there a way I can keep id in? I need to declare it so I can't leave it out.

[benphp]

If ID is unique, and it sounds like it, then select distinct will return everything.

 

You could select ID within your sql results

 

SELECT DISTINCT game FROM ladders

while {

 

SELECT id FROM ladders where game = $dbgame LIMIT 1

 

}

 

This is conceptual of course.

[mrdamien]

SELECT id, game FROM ladders WHERE game IN ( SELECT DISTINCT game FROM ladders )

 

try that

 

Edit: wait, no im getting confused.

[mrdamien]

Its generally faster to query only once. This is still less efficient than the query you want, but I can't figure this one out:

<?

$results = mysql_query('SELECT id, game FROM ladders');

$games = array();

while($row = mysql_fetch_assoc($results)){

    if(in_array($row['game'], $games)){

          // Do nothing, already used

    }else{

          // Do stuff.

          $games[] = $row['game'];

    }

}

?>

[SocomNegotiator]

That did work...thanks a lot man!!!