Meerde gebruikers ophalen

Ik heb dit:

[COLOR= #0000BB]<?php
                                    $get[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users WHERE gekocht = 1"[/COLOR][COLOR= #007700]);[/COLOR]
                                    [COLOR= #0000BB]$get2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$get[/COLOR][COLOR= #007700]);[/COLOR]
                                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$get2[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]];[/COLOR]
                                    ?>

ik wil dus alle namen weer geven die iets hebben gekocht. alleen hij haalt er maar 1 op terwijl en meerder zijn?

[COLOR= #0000BB]<?php
$get[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users WHERE gekocht = 1"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$get2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$get[/COLOR][COLOR= #007700]))
{[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$get2[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]];
}[/COLOR]
?>

zo dus

Thanks, hoe zorg je er voor dat er overal een komma komt en bij de laaste naam niet?

Dus:

Piet, Jan, Kees, Robb

[COLOR= #0000BB]<?php
$get[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users WHERE gekocht = 1"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$count[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$get2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$get[/COLOR][COLOR= #007700]))
{[/COLOR]
  [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$get2[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]];[/COLOR]
  [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$get[/COLOR][COLOR= #007700]) !=[/COLOR] [COLOR= #0000BB]$count[/COLOR][COLOR= #007700]) 
  {[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000], [/COLOR][COLOR= #007700];
  }[/COLOR]
  [COLOR= #0000BB]$count[/COLOR][COLOR= #007700]++;
}[/COLOR]
?>

Zo volgens mij

Habbooo schreef:

[COLOR= #0000BB]<?php
$get[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users WHERE gekocht = 1"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$count[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$get2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$get[/COLOR][COLOR= #007700]))
{[/COLOR]
  [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$get2[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]];[/COLOR]
  [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$get[/COLOR][COLOR= #007700]) !=[/COLOR] [COLOR= #0000BB]$count[/COLOR][COLOR= #007700]) 
  {[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000], [/COLOR][COLOR= #007700];
  }[/COLOR]
  [COLOR= #0000BB]$count[/COLOR][COLOR= #007700]++;
}[/COLOR]
?>

Zo volgens mij
Is juist
Trouwens, geef duidelijke namen aan je querys, dat maakt je script overzichtelijker