Selecting Only 1 Product From A Database ...

[eukhost]

Hello,

Please can any one help me on selecting the product name from a database only once e.g. if a search is performed for a AMD and there is 2 AMD XP 1800+ in the database then it would only display one of them.

My code is:
result = mysql_query("SELECT * FROM products where manufacture=$manufacture AND category=soundcards, order by name asc",$db);
while ($data = mysql_fetch_array($result)) {
echo "";
}

Thank you for your time,

[sid]

SELECT DISTINCT * FROM products where manufacture=$manufacture AND category=soundcards, order by name asc

[eukhost]

Thanks alot mate

[sid]

no problemo dude