AT http://crockett.ca/joinoptional.php I have a page posted. PHP isn't set up on the server, so I've posted a screenshot of what it looks like at http://crockett.ca/joinoptionalrendered.bmp (1/2 MB, sorry). For some reason, it wants to repeat 'Victoria' in the form. If I comment out the If conditional: // if ($city = "Victoria") { // echo "selected "; // } ..the problem goes away and the different cities appear as expected. The result of the query is at http://crockett.ca/queryresults.txt Can someone point me in the right direction? Brad Crockett Duncan BC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php