Another PHP problem has kept me up all night, scouring through my database books and trying everything I could think of. I am still new to the MySQL and PHP field, but never the lass I will not give up. $cat is a variable that is passed to the query from the previous page. The SELECT statement works faultlessly, except for the point at which no choice is made from the drop down on the page prior to this one. I have set a value of "x" to the drop down for a non selection, but am having problems converting that "x" value to a "%" value (the MySql wildcard symbol) withing my SELECT statement. I am assuming that I will need an IF THEN before the SELECT, but I have tried several variation to no avail. $result = mysql_query("SELECT CompetitorName FROM competitor, competitorproducts, productcategory WHERE competitorproducts.CompID=competitor.ID AND productcategory.ID=\"$cat\" AND competitorproducts.CatID=productcategory.ID" ); Any help would be mostly appreciated. Thanks. Neil Silvester Webmaster / Systems Administrator Heat and Control Inc.