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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
