HTML and PHP

sangklee

I used php on my web page and it displays part of php script on my web page.
Does anybody know what I am doing wrong?
Here is link to the problem page and php script that I used on that page.

http://www.youngsmall.com/cgi-local/shop.pl/page=index222.htm

<?php
$link = mysql_connect("xxxxx","xxxx","xxxx")
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 "Out of Stock";
} else {
echo "In Stock";
}
mysql_close($link);

?>
Thanks for your time.
Tony

Anon

$sql = "SELECT quantity FROM inventory WHERE item = '$itemx'";
$result = mysql_query($sql,$link);
$num = mysql_result($result,0); / the quantity of the item with id=6505. i'm assuming that the id is unique. /

About the webpage: looks like it's a perl-script, not php...? I mean it's in the cgi-bin and "shop.pl"..