Re: Supplied argument is not a valid MySQL result

Because you are enclosing your $sql string within () brackets, $sql is being set a boolean value, not the value of the string. Change it to $sql = "SELECT * ... '$group_id'"; -Mike Dan McCullough wrote:

Warning: Supplied argument is not a valid MySQL result resource in /home/sites/projects.heathermccullough.com/web/copeland/product.php on line 61 Here is the code, I fixed it once, and I cant figure out why it keeps returning. if ($submit) { $sql = ("SELECT * FROM store WHERE state = '$State' AND groups = '$group_id'"); $result = mysql_query($sql); if(mysql_num_rows($result) > 0) { < - line 61 while ($stores = mysql_fetch_array($result) ) { $store_name .= "".$stores["name"]." <br> ".$stores["address"]." <br> ".$stores["city"].", ".$stores["state"]." ".$stores["zip"]."<br>".$stores["phone"]." <br><br> "; } } else { $store_name .= "Copeland Furniture Company Store<br>Main Street<br>Bradford, Vermont 05033<br>802-222-5300<br><a href=\"http://www.copelandfurniture.com/companystore\" target=\"new\">Copeland Furniture Company Store</a>"; } MYSQL_CLOSE(); ===== Dan McCullough ------------------------------------------------------------------- "Theres no such thing as a problem unless the servers are on fire!" h: 603.444.9808 w: McCullough Family w: At Work __________________________________________________ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com