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["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>";

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

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]

Reply via email to