Re: php script showing up on web page!!!!

From: 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 > > > >

« previous php.db (#10725) next »