[thelist] MySQL Table fields

[Andrew Maynes]

I have done this and it just isn't working, tried lots of changes :(

commonHeader("$Company","Select an item");
$result=mysql("$DBName","SELECT items.ItemSKU, items.ItemName,
items.ItemDescription, items.ItemCost, items.Category, items.ShippingCost,
items.ItemID, category.Category FROM Items INNER JOIN category.Category ON
items.Category = category.Category WHERE items.ItemID='$II'");

I get this error

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result
resource in c:\program files\apache group\apache\htdocs\cart\items.php on line
33


Andrew