[PHP-DB] extracting unique entries from mysql dbase
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 - SongbirdsLINK 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
Re: [PHP-DB] 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 - SongbirdsLINK 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
Re: [PHP-DB] 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 - SongbirdsLINK 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
