[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
http://www.howcheng.com/
howcheng at ix dot netcom dot com
AIM: bennyphoebe
ICQ: 47319315
More information about the thelist
mailing list