|
|
Posted by J.O. Aho on 12/19/06 14:58
rukkie wrote:
> Some addition :
>
> the commands used in PHP to see the result are :
>
> while($nt=mysql_fetch_array($result5)){
> if ($nt[col1] <> "") {
you should use empty() and not <>
> As a result I fsee some double entries, which is not the idea .... Very
> strange behaviour or very stupid programming of me ?
>> I'm using this query :
>>
>> $query5="SELECT DISTINCT col1,col2 FROM db WHERE (col1<>\" \") ORDER BY
>> col1,col2 asc";
What about:
SELECT DISTINCT CONCAT(col1,col2) FROM db ORDER col1,col2 asc
--
//Aho
Navigation:
[Reply to this message]
|