Re: extracting unique entries from mysql dbase

Tim, In your query use SELECT DISTINCT, rather than SELECT. That way you will not get duplicates returned from the database. Miles At 08:49 PM 9/12/2002 -0700, Godzilla wrote:

Hi everyone, I have a mysql row similar to the list below. What I need to do is have php output a link list from this. I'm new to php but in my head I picture something like: <? "foreach unique entry" in $row_links['dbase'] { echo "<a href=$PHP_SELF?catagory=Wind Chimes - Classic Hand-Tuned Collection - Songbirds>LINK TEXT</a>"; } ?> The links will be on the same page thus the $php_self. The script will take a GET variable called "category" to display the proper items from the dbase. It's the foreach statment or whatever it should be that I need a bit of help with. Any ideas would be greatly appreciated! Thanks, Tim Wind Chimes - Classic Hand-Tuned Collection - Songbirds Wind Chimes - Classic Hand-Tuned Collection - Songbirds Wind Chimes - Classic Hand-Tuned Collection - Songbirds Wind Chimes - Classic Hand-Tuned Collection - Songbirds Wind Chimes - Classic Hand-Tuned Collection - Songbirds Wind Chimes - Classic Hand-Tuned Collection - Songbirds Wind Chimes - Classic Hand-Tuned Collection - Songbirds Wind Chimes - Constellations Wind Chimes - Constellations Wind Chimes - Constellations Wind Chimes - Constellations Wind Chimes - Duets Wind Chimes - Duets Wind Chimes - Duets Wind Chimes - Duets Wind Chimes - Energy Chimes Wind Chimes - Energy Chimes Wind Chimes - Energy Chimes Wind Chimes - Energy Chimes Wind Chimes - Energy Chimes Wind Chimes - Geotunes Wind Chimes - Geotunes Wind Chimes - Geotunes Wind Chimes - Geotunes -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php