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]