Thanks very much Nicholas,
Sean.
""Nicolas Guilhot"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> You can try to modify your SQL query and add the "DISTINCT" statement !!
It
> will return each distinct row only once.
>
> example "SELECT DISTINCT cat_id, cat_name FROM categories"
>
> Regards,
>
> Nicolas
>
> -----Message d'origine-----
> De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Envoyé : mercredi 9 mai 2001 12:02
> À : [EMAIL PROTECTED]
> Objet : [PHP] Print array items only once
>
>
> Hi all,
>
> I am querying the categories field in my database to rurn the various
> categories that can be clicked on.
>
> Problem is, if I have 5 items in a category, my categories query lists the
> category 5 times..
>
> I am trying to work out how to say:
>
> while($qry = mysql_fetch_array($res)){
> print $res["category"]; but only once for this results array.
> }
>
> Can you help with this?
>
> Many thanks.
>
> Sean.
>
>
>
> --
> 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]
>
--
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]
