 |
 |
Find a programming school near you
php-db | 2002091
Date: 09/13/02
- Next message: Angelo Marcos Rigo: "[PHP-DB] converting txt to postgresql"
- Previous message: Miles Thompson: "Re: [PHP-DB] extracting unique entries from mysql dbase"
- In reply to: Godzilla: "[PHP-DB] extracting unique entries from mysql dbase"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Next message: Angelo Marcos Rigo: "[PHP-DB] converting txt to postgresql"
- Previous message: Miles Thompson: "Re: [PHP-DB] extracting unique entries from mysql dbase"
- In reply to: Godzilla: "[PHP-DB] extracting unique entries from mysql dbase"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
