Re: extracting unique entries from mysql dbase

What you want to do is common, everyday stuff. There are lots of examples. There's a fine manual at www.php.net, fully commented. If you have a look at mysql_query() I believe there is an example in the explanatory text / comments on how to use the returned results. There are also lots of tutorials and examples, key words would be php, database web site. And, as always, Juli Meloni's www.thickbook.com, which has some really well-developed tutorials. Hope this points you in the right direction - Miles Thompson 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