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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
