Re: php script showing up on web page!!!!
| From: | Phillip Bow | Date: | Tue, 24 Jul 2001 22:54:30 +0000 |
| Subject: | Re: php script showing up on web page!!!! | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10725@lists.php.net to get a copy of this message | ||
Well unless you set up your webserver to parse .htm pages then your code
will not be parsed and is displayed as plain text.
--
phill
"Tony" <tony777@qwest.net> wrote in message
news:20010724205428.75944.qmail@pb1.pair.com...
> Here is the link to the problem page,
>
> http://www.youngsmall.com/cgi-local/shop.pl/page=index222.htm
>
> This PHP script shows up below "buy now" button.
> Can anybody tell me what I am doing wrong?
> This is script that I am using on each buy buttons,
> <?php
> $link = mysql_connect("xxxxx","xxxxxx","xxxxxx")
> or die ("Could not connect");
>
> if (! @mysql_select_db("xxxxx") ) {
> echo( "<P>Unable to locate the inventory " .
> "database at this time.</P>" );
> exit();}
>
> $itemx = "6505";
> $sql = "SELECT quantity FROM inventory WHERE item = '$itemx'";
> $result = mysql_query($sql,$link);
> $row = mysql_fetch_array($result);
> // you have to fetch the result into an array to access the info in the db
> $num = $row["quantity"];
>
> // NOW we can compare $num ;)
> if ($num < 1) {
> echo "<b><font color=\"#FF0000\">Out of
> Stock</font></b>";
> } else {
> echo "<b><font color=\"#0000FF\">In
> Stock</font></b>";
> }
> mysql_close($link);
>
> ?>
>
> Thanks for your time.
> Tony
>
>
>
>