SQL SELECT query echoing twice even with DISTINCT

Street

New Member
I am creating a simple SQL query in PHP - and for some reason, even when \[code\]DISTINCT\[/code\] is used, it shows twice like this:\[code\]BCBCOHOHTXTX\[/code\]Here is my code:\[code\]<?php$sql = "SELECT DISTINCT `title`,`extra_fields_search` FROM `blahblah_items` WHERE catid=336 ORDER BY `blahblah_items`.`extra_fields_search` ASC ";$partnerlisting= mysql_query($sql) or die(mysql_error());while($row = mysql_fetch_assoc($partnerlisting))foreach($row as $cname => $cvalue){echo '<li>'.substr($row[extra_fields_search], 0, 2).'</li><br>';};?>\[/code\]How can I make it so it prints out only one of each?
 
Top