[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]
RE: [PHP] Print array items only once
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]
Re: [PHP] Print array items only once
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]