doff, I knew there had to be a simple answer. Works great, thanks.
At 02:26 PM 2/21/01 +1300, Simon Garner wrote:
>From: "Jared Howard" <[EMAIL PROTECTED]>
>
>> I'm make an object or an array from the results of a query to my MySQL
>> database. The value returned is entered in <option>s and any repeated
>> values are unwanted. Is there a way to remove them easily?
>>
>> eg.
>> <select>
>> <? $qid = mysql_query("SELECT this FROM that WHERE here");
>> while ($r = mysql_fetch_object($qid)) { ?>
>> <option><?=$r->this?></option>
>> <? } ?>
>> </select>
>>
>> I was thinking of creating an array before the while, then in the while
>add
>> each "$r->this" if "(! in_array($arr))". Then I would have to do another
>> while with the <option> included. But I'm not really sure how to add
>> elements to existing arrays. And that might not even be the best way.
>Any
>> iteas?
>>
>
>
>IMHO: always make the database manipulate the data for you, if it can. It's
>usually much faster, and requires less code.
>
>In this case just do:
>
>SELECT DISTINCT this FROM that WHERE here
>
>and you won't get any duplicates. Great huh? :)
>
>Refer to the MySQL manual at http://www.mysql.com/docs/ for more details.
>
>
>Cheers
>
>Simon Garner
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
