Re: [PHP-DB] extracting unique entries from mysql dbase

2002-09-13 Thread Miles Thompson
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

Re: [PHP-DB] extracting unique entries from mysql dbase

2002-09-13 Thread Miles Thompson
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 tuto

[PHP-DB] extracting unique entries from mysql dbase

2002-09-12 Thread Godzilla
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: LINK TEXT"; } ?> The links will be on the same page thus the $php_self. The script will take a GET variable called "cate