[thelist] MySQL Table fields

Andrew Maynes andrew at humanbehaviour.co.uk
Thu Jan 23 13:50:01 CST 2003

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


More information about the thelist mailing list