I have a website which has, among other things, virtual items. The items are stored in table items, the different types of items in item_types. I use the following query to get a user's items: SELECT DISTINCT t1.id,t1.itemtype,t2.name FROM items as t1,item_types as t2 WHERE (t1.itemtype = t2.id AND t1.owner = '$theirrealinfo[username]' AND t1.placein='inventory')
A few minutes ago, items mysteriosly started getting then followowing error from mysql_error(): "Got error 28 in table handler". Thanks to anyone who can help! P.S. They just started working again. I'm still sending this because I want to know what was wrong. Thanks again!