Got it to work. I had made a change that deleted something, not sure what, but when I
went back a
revision it worked, and I just added back in the html that I needed to use, but I was
more
careful.
--- Richard Lynch <[EMAIL PROTECTED]> wrote:
> 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'");
>
> The ()s here are kinda silly... They tell PHP to evaluate the string
> before anything else in the expression, and there ain't anything else in
> the expression...
>
> It's like saying:
>
> $foo = (2 + 3);
>
> Doesn't hurt anything, but you look a bit silly...
>
> > $result = mysql_query($sql);
>
> Add some code to the end of this line.
>
> At a minimum, use ... or die(mysql_error());
>
> That's actually not so good on a production server, as it will present icky
> error messages to end users, some of whom might be hackers who then know
> more than they should about the internal working of your
> page/database/site...
>
> So, better is:
> ... or error_log(__FILE__ . ' ' . __LINE__ . ': ' . mysql_error());
>
> only now you'll have to do the following in a shell prompt:
>
> tail /usr/local/apache/logs/error_log
>
> to see your error message.
>
> > 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();
>
> --
> Like music? http://l-i-e.com/artists.htm
>
>
> --
> 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]
>
=====
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]
