php script showing up on web page!!!!
| From: | tony | Date: | Tue, 24 Jul 2001 20:51:23 +0000 |
| Subject: | php script showing up on web page!!!! | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10723@lists.php.net to get a copy of this message | ||
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