[thelist] MySQL Table fields

Howard Cheng howcheng at ix.netcom.com
Thu Jan 23 14:30:01 CST 2003

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
howcheng at ix dot netcom dot com
AIM: bennyphoebe
ICQ: 47319315

More information about the thelist mailing list