[thelist] MySQL Table fields

[Howard Cheng]

MySQL is case-sensitive, so items and Items are not the same.

Also, you can check if you have a valid result and if not, print the error.

if (!$result) echo mysql_error();
else {
    ...
}

At 07:54 PM 1/23/2003 +0000, Andrew Maynes wrote:
>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'");

::::::::::::::::::::::::::::::::::
Howard Cheng
http://www.howcheng.com/
howcheng at ix dot netcom dot com
AIM: bennyphoebe
ICQ: 47319315