This has nothing to do with PHP. Subscribe to a database list. Use DISTINCT or GROUP BY
---John Holmes... > -----Original Message----- > From: Philip J. Newman [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 18, 2002 8:39 PM > To: [EMAIL PROTECTED] > Subject: [PHP] Newman Says: Only one value from a msSQL field. > > Only one value from a msSQL field. > > I have many values the same in a field and would like to know how i can > select one of each (not mating). > > $sql = "SELECT * FROM brands WHERE 1 ORDER BY `sId` DESC LIMIT 6"; > > lists everything .. > > ANy help would be cool. > > Phil > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php