Form problem

Taneya

hi everyone - yet another question from a newbie🙂

Can someone tell me how to eliminate duplicates from my form select box?

Here is the actual page
http://www.taneya-kalonji.com/php/designersearch.php

however, as you can see, a designer is listed multiple times. I am not sure why as in the table that this draws from each designer in only listed once.

Here is my code
http://www.taneya-kalonji.com/dump/search.doc

on which i used this page as a guide.
http://www.thickbook.com/extra/php_loopoption.phtml

Once a name is chosen however, everything else works fine. any suggestions? Thanks in advance!

Taneya

wilsonodk

I noticed a small problem

// You have this...
if ($result && (mysql_numrows($result) > 0 )) 

// ...and it should be...
if ($result && (mysql_num_rows($result) > 0 ))

And i would double check that the PHP page you spelled DISTINCT properly, I've been known to do that. And you have the code in a .doc file so it may have spelled corrected it for you. Maybe?

Good Luck

Taneya

thanks for the info. I fixed the line you mentioned but that still did not do it. And, I also double checked the spelling of Distinct and it was correct.

So, i must have done something else wrong...

thanks though.

hrosas

HI Taneya I found a little problem in your script it's little as a dot in the line
$option_block (this one -->).= "<OPTION value=\"$name\">$name</OPTION>"; if you remove it you'll get what you want.

Hector

http://www.oksonora.com

Taneya

that did it! Thanks Hector!!!!!