distinct and trim

[ace21]

Is there any way to incorporate a distinct and trim? Or is this something that can only be done on the insert?

example
select distinct category

"clothes"

is different then

"clothes "

[[deleted]]

have you tried it?

[ace21]

lots of different ways
although maybe I am looking at it wrong

I figured this to be a way to do it but it just returned an empty result

select distinct trim(category)

[[deleted]]

it seems to work ok from the commandline. Possibly a bug in your script?

[ace21]

<select name=manufacturer>\n";
$sql = "select distinct trim(manufacturername) as mname from tblProducts order by manufacturername";
if(!$result = mysql_query($sql))
{
echo mysql_errno().": ".mysql_error()."<br>$sql";
exit;
}
while($row = mysql_fetch_array($result))
{
$manufacturername = $row[mname];
echo "<option value='$manufacturername'>-$manufacturername-";
}
echo "</select>";

Ok I have gotten farther. I forgot the as mname portion. But I still see both entries with a space and without.