Re: quick question

Hello Jeremy, use 'GROUP BY username' in your query and will combine all records with same username into one record. /Merle Tuesday, October 09, 2001, 2:05:11 PM, you wrote: JM> Hi everyone, JM> just forgot how to do something.... JM> I would like to query the records where the "username" is different. In my JM> table a lot of them are Identical and I only want them once in my result JM> $connection = @mysql_connect("localhost", "hpool", "cdi986") or JM> die("Couldn't connect."); JM> $db = @mysql_select_db($db_name, $connection) or die("Couldn't select JM> database."); JM> $sql = "SELECT uid, username JM> FROM users JM> "; JM> $result = @mysql_query($sql,$connection) or die("Couldn't execute query."); JM> Thank You.