Big problem....need help

From: Date: Wed, 09 Jul 2003 13:13:42 +0000
Subject: Big problem....need help
Groups: php.general 
Request: Send a blank email to php-general+get-154542@lists.php.net to get a copy of this message
I have a table like this: ------------------------------------------------------------------------------------ - product_id - mark_name - category_name - ------------------------------------------------------------------------------------ - 1 - aaa - catg 1 - - 2 - bbb - catg 2 - - 3 - aaa - catg 1 - - 4 - ddd - catg 1 - - 5 - bbb - catg 2 - ------------------------------------------------------------------------------------ and so on I want to show all the mark_name in a category only once (if they more than once) I have this code: ...... $sql = "SELECT * FROM products, category WHERE category.name_category=products.name_category and category_id=".$_GET['category_id'] ; $rezultat = mysql_query($sql); while ($row=mysql_fetch_array($rezultat)) { echo "<b>Name:</b> ".$row["mark_name"]."<br>\n"; } .......... When i choose the category catg 1 the result is Name: aaa Name: aaa Name: ddd As you can see the name aaa appears 2 times insted 1. How to make the result look like this: Name: aaa Name: ddd

« previous php.general (#154542) next »